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 |
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