E9.2 Display data from different table in a single line record

[Yu Hong]

I'm having 2 data request (F4102 & F0006). F4102 data request will return multiple records of MCU(Business Unit), whereas F0006 data request cross reference with F4102 MCU and return respective DC (Description Compressed).

Any solution to return F0006.DC together with F4102 rowset? Thanks in advance!

 

[lfurino]

You would need to include the business unit in the second data request as well, but you can do this with a groovy script. Start by reading both records sets into two separate JSON arrays and then use a nested for loop to iterate through the first array and then lookup the corresponding description in the second array where there is a match on MCU. The groovy script could either be in a custom request inside the orchestration or in the manipulate output section at the end of the orchestration depending on what you are trying to do.

The second option is to use a SQL connector and write a SQL select statement in groovy with your join in there.

The third option is to create a business view that already has everything joined and create your data request over that.

 

[Yu Hong]

You would need to include the business unit in the second data request as well, but you can do this with a groovy script. Start by reading both records sets into two separate JSON arrays and then use a nested for loop to iterate through the first array and then lookup the corresponding description in the second array where there is a match on MCU. The groovy script could either be in a custom request inside the orchestration or in the manipulate output section at the end of the orchestration depending on what you are trying to do.

The second option is to use a SQL connector and write a SQL select statement in groovy with your join in there.

The third option is to create a business view that already has everything joined and create your data request over that.

It works ! Thanks !