Hi Community,
I would like to ask whether understanding on the union tools is correct or not.
I have three sets of data as below :
1.Data A with three column with below
- Customer Name Invoice Number Invoice Date
2. Data B with five column as shown below :
- Company Code Invoice Number. Invoice Amount Invoice Date Customer Name
3. Data C with two column as shown below:
- Invoice Number Invoice Date
If I join these three data together using union tools ,can I get the results will be as follow
- Company Code Invoice Number Invoice Amount Invoice Date Customer Name
Can Alteryx auto configure by name if I use join tools in this case?