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
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
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
Go to Solution.
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
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!
Hi @Emil_Kos and @leon2020 ,
I'm really glad that you found this solution helpful and thank you for taking the time to write a comment and share it.
Unfortunately, it's a manual process to configure the union tool, but it will work if it's a one-off.
Enjoy the rest of your day!
@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.