Hi Alteryx Community,
I'm trying to convert a file with multiple columns of hierarchy data (each pair of columns is a different level in the hierarchy, a code and an alias) into just two columns - one with all of the codes and the next with the matching aliases.
Please see the attached file I mocked up, with an example input and output.
Any help would be greatly appreciated!
Thanks!
Solved! Go to Solution.
Hi @JAB95 I came up with an approach that pivots the data and then extracts the relevant information from the headers to help sort the data when I then use a crosstab to pivot the information into the format you provided. It uses Regex to extract the information from the headers before the data goes into the crosstab tool.
@JAB95 one way of doing this with
Transpose the data and filter out based on the value 'Code' or 'Alias'
join with position
sort