Union the tables irrespective of the fields

[Vighnesh_Ivaturi]

Hi all. I have data with customer names and their net and gross amounts for their different services and union both the tables. The customers depend on the different input files I send through the flow. Suppose AR,BR,CR are the services with the net and gross amount for the below customers. Now if I change the customer input file - they have different services with net and the gross amount. When I try to union them It gives error If the service which was available in the previous customer's file was not found. How can I union the data irrespective of the services? Please help me with this

NET AMOUNT
CUSTOMER	AR	BR	CR
123	0	0	0
124	0	100	12
125	0	0	34
126	0	23	0
127	0	0	0
128	0	0	0

GROSS AMOUNT
CUSTOMER	AR	BR	CR
123	0	0	0
124	0	140	30
125	0	0	60
126	0	50	0
127	0	0	0
128	0	0	0

[Felipe_Ribeir0]

Hi @Vighnesh_Ivaturi 

Your problem is that each file can have a different set of columns, right?

You can use the input batch macro, it will union the columns when the column name is the same, and create a new one when it is different.

Take a look at this topic, the workflow is attached.

The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten