AnsweredAssumed Answered

Need multiple outputs from a single sql lookup

Question asked by AbhijatKumar1761 on Apr 15, 2015
Latest reply on Jan 19, 2018 by rohit_tiwari

My client has a requirement for retrieving multiple output fields (SKU's) from a single document  through a sql lookup on order_id.
For more details:
Say an inbound XML has order_id's and every order_id has multiple SKUs associated. Through normal sql lookup it returns only a single SKU per order_id as an output to be mapped later which is needed to be multiple outputs which can be mapped as a loop.

Say O_id has SKU1, SKU2, SKU3. Sql Lookup currently fetch a pair of O_id, SKU1. What I need is all SKUs as an output related to O_id which I can map to a loop in output profile.

Outcomes