Hi! I need to transform this table which have 18000 rows (3000 employees):
Into this one:
Each employee should have just 1 row of values, making KAP-Audit, PIC-Audit & EQR-Audit as columns. If more than 1 value in those columns, should be on the same row but with a line break. It's possible those rows do not have any values, 1 value or up to 10 values in each column.
Also attached the flow with input file and the desired output.
Thanks in advance!
Solved! Go to Solution.
Hey @VictoriaBuet,
Here is one way to do this with the corss tab tool:
The \n separator creates a new line.
This solution uses the cross tab tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done
Any questions or issues please ask!
Hope that Helps
Ira Watt
Technical Consultant
Watt@Bulien.com