Hi I have a dataset but it is is not align properly because of missing data, now I have to move those columns to the right
Example:
Id | name | place | quantity | price | fruit | row number |
456214 | Alex | tokyo | 5.00 | 15.23 | apple | 1 |
456214 | Raj | 10.00 | 100.00 | apple | 2 | |
456214 | Tim | new york | 10.00 | 10.00 | banana | 3 |
456214 | 25.00 | 125.23 | banana | 4 | ||
145267EX | Nick | UK | 5.00 | 20.00 | apple | 5 |
145267EX | Luffy | 5.00 | 60.00 | apple | 6 | |
145267EX | 10.00 | 80.00 | banana | 7 | ||
54123 | Leo | LA | 5.00 | 10.00 | apple | 8 |
54123 | 5.00 | 10.00 | apple | 9 |
Condition:
1. If you will see row number 2 and 6 the place is missing so to align it correctly I have to move all the columns one to the right
2. If you will look at row number 4 and 9 the alignment is correct So we don't have to do anything
Output:
Id | name | place | quantity | price | fruit | row number |
456214 | Alex | tokyo | 5.00 | 15.23 | apple | 1 |
456214 | Raj | 10.00 | 100.00 | apple | 2 | |
456214 | Tim | new york | 10.00 | 10.00 | banana | 3 |
456214 | 25.00 | 125.23 | banana | 4 | ||
145267EX | Nick | UK | 5.00 | 20.00 | apple | 5 |
145267EX | Luffy | 5.00 | 60.00 | apple | 6 | |
145267EX | 10.00 | 80.00 | banana | 7 | ||
54123 | Leo | LA | 5.00 | 10.00 | apple | 8 |
54123 | 5.00 | 10.00 | apple | 9 |
What will be the best method to push the row to the right
Note: We can only use alteryx tools.
Attaching the csv file for the above table
Solved! Go to Solution.
Hi @Sshasnk ,
I have managed to do whta you are looking for with a filter tool and then a union tool, in which I have manually configured the columns.
That's one way to do it and will solve your problem until you output the data in the right format.
Hope that helps
Angelos
Hi @AngelosPachis,
This is smart. Easy to implement and easy to explain to others. I will remember this solution for the future.
@AngelosPachis that's beautifully simple.
I had a similar issue myself, and went via a more convoluted route :
It worked, but yours is much more elegant 🙂
...and I knew you could do that, clearly didn't occur to me at the time!
@Sshasnk
Can you also give feedback to your another thread?
I believe the repliers would appreciate your feedback and even better you would mark it as acceptable if you find the anwser useful.