Hi team,
I am stuck on one thing I need to do in ateryx I need to do.
I have a set of data from accounting deparment - document numbers and related account numbers. Currently I have 1 column with all document numbers and another one with accounts. The problem is, that to one document number, there are several account numbers which I need to bring into one row with the document number (see below how it should look like).
Input | Output | |||||||||
Doc number | Account | Doc number | Account | Account | Account | Account | Account | Account | ||
1 | abc | 1 | abc | def | ||||||
1 | def | 2 | abc | def | ||||||
2 | abc | 3 | def | ghi | mno | |||||
2 | def | 4 | abc | jkl | ghi | |||||
3 | def | 5 | abc | def | ghi | jkl | mno | pqr | ||
3 | ghi | |||||||||
3 | mno | |||||||||
4 | abc | |||||||||
4 | jkl | |||||||||
4 | ghi | |||||||||
5 | abc | |||||||||
5 | def | |||||||||
5 | ghi | |||||||||
5 | jkl | |||||||||
5 | mno | |||||||||
5 | pqr |
Ive tried to do that with some summarize, transpose or cross tabs, but clearly I am doing something incorrectly.
Can anybody help?
Thanks in advance.
Solved! Go to Solution.
Hi @DominikaD ,
you could use a Multi-Row formula tool to add a "counter" to the accounts for each document - it's possible to cross-tab rows to columns then. Attached a sample workflow. Hope this is helpful.
Best,
Roland
Thank you!
You are my absolute hero!