I want union data as below:
Input 1:
Name :
A
B
c
Input 2
ID:
11
12
21
22
31
32
Expected output:
C
How about something like this?
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?
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?