Hello everybody, i am having trouble joining three columns and i don't know what else to do. I have three different columns generated by alteryx, Example:
If i use the union tool the output is this one:
| DATA A | DATA B | DATA C |
| 1 | | |
| 2 | | |
| 3 | | |
| 4 | | |
| 5 | | |
| | 8 | |
| | 123 | |
| | 43 | |
| | | 32 |
| | | 4 |
And i need this one:
| DATA A | DATA B | DATA C |
| 1 | 8 | 32 |
| 2 | 123 | 4 |
| 3 | 43 | |
| 4 | | |
| 5 | | |
Maybe it is a stupid question, but i have tried a lot of options unsuccessfully.
Thank you so much for your help!!