Multiple data streams to union in batch macro

Question

Hi,

I want to build a batch macro based on below conditions::

Input Data stream 1

Input data stream 2: Here I have groups and given them a sequence number

I want to pass one set of group from data stream 2 and union them with data stream 1 inside the macro.

I want to to this for all groups one group at a time . I am doing this because there row based operations involved which requires rows to be passed one by one , so before passing another group there must be transformation applied to previous set.

I am facing cross join kind of issues here.

Could you please guide?

krishcode0 · Answer

Thanks @Qiu @MatthewO

Please have a look attached flow.

Output is yet to be achieved :)  , qualified rows will go one by one and offer attempt would be decided based on row above or row below for qualified records. I am not unioning them all together because in that case value of offer attempt column will be null for all qualified records and then we won't be able to assign based on above and below.

Hope I tried to made my point.

Thanks in advance for help.

New Workflow3.yxzp

Qiu · Answer

@krishcode0 
Agree with @MatthewO , Can you show us a sample output?

And better you can provide the data in text format rather than in Picture. 😁

MatthewO · Answer

@krishcode0 do you have an example of the desired output?