Conditional Union

[Amit_Rastogi]

I want union data as below:

Input 1:

Name :

A

B

c

Input 2

ID:

11

12

21

22

31

32

Expected output:

A

11

12

B

21

22

C

31

32

[LordNeilLord]

Hey @Amit_Rastogi 

In the union tool you can choose the "manually configure fields" this will give you want! Or you could just rename one of the columns before the union?

[LordNeilLord]

Actually looking at your output I suspect there is more to it than that, you'll need to give more examples of the logic needed...like how does A link to 11 & 12?

[Amit_Rastogi]

Actually i have dynamic input columns in input 1 whereas the input 2 have static collection of column:

Input 1:(column will change as per user selectiion)

Product

Category
Item

Input 2: (fixed column):

Sum

Count

Group by

I want to generate new file having out like:

01 | Product

11 | Sum

12 | Count

13 |Group by

02 | Category

21 | Sum

22 | Count

23 | Group by

03 | Item

31 | Sum

32 | Count

33 | Group by

[DavidP · Accepted solution]

How about something like this?

[Amit_Rastogi]

Thank you.. this is what i am looking for.. 🙂