Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.
SOLVED

Please help in combining these 2 files

yharyani
5 - Atom

I have been able to correct data in Categories file using Text to Columns.

The data file is the one I am struggling with; I have tried transpose and cross tab but didn't work. After cleaning the data I have to combine the 2 files, please help.

1 REPLY 1
cjaneczko
13 - Pulsar

Try the following configuration. In the Transpose Tool, select Info_Category as your key column. In the Text to Columns tool, select Split to Rows. Then join on the ID's with a Join tool. 

 

image.png