Say I have a data stream with a key column and a significant number of other columns all populated as "Unused".
Key | A | B | C | D | E | F | G | H | on and on it goes |
Bill | Unused | Unused | Unused | Unused | Unused | Unused | Unused | Unused | Unused |
Ted | Unused | Unused | Unused | Unused | Unused | Unused | Unused | Unused | Unused |
Then I have a separate stream with a Key column and another column containing the name of one of the columns from the first stream.
Key | Column Name |
Bill | B |
Ted | E |
I want to somehow manipulate the data from the first stream to show "Allocated" where the "Column Name" data in the second stream matches a column name from the first stream.
Key | A | B | C | D | E | F | G | H | I |
Bill | Unused | Allocated | Unused | Unused | Unused | Unused | Unused | Unused | Unused |
Ted | Unused | Unused | Unused | Unused | Allocated | Unused | Unused | Unused | Unused |
I'm struggling to figure out how to do this. Can someone help?
Solved! Go to Solution.
@Stringpark Thankfully this is not a most heinous solution to your most excellent problem, dude.
By using the righteous powers of alteryx we can transpose the original data and join on the column name.
The attached workflow should get you further on your most excellent adventure.
Be excellent to each other and Party on, dude.
This is excellent! Thank you @neilgallen!