Multiple data streams to union in batch macro

[krishcode0]

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?

[MatthewO]

@krishcode0 the Append Fields tool will yield the result of a cross join. I don't fully understand the requirement around row-level operations. However, you could potentially use a Multi-Row Formula tool compare records from the previous group after they have been joined.

[krishcode0]

Hi @MatthewO 

Table 1:

Table 2:

I want to bring records from table 2 one by one and merge(union) them to Table 1, I am bringing them 1 by 1 because I would need to calculate offer attempts present in Table 1 based on row-1 and row+1 operations as Table 2 doesn't have Offer attempts.

[MatthewO]

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

[Qiu]

@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. 😁

[krishcode0]

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.