Hi,
New to ALteryx, I have two tables one has the employee details and the other has hierarchy details as shown below
Table A
EMPLOYEE ID | USERID | FirstName | LastNAme |
123456 | test1 | IAM | TEST |
245678 | Test2 | HELLO | TEST2 |
345789 | Test3 | Iam | LEGEND |
458905 | Test4 | TERMINATOR | II |
Table B
EMPLOYEE ID | USERID | LEVEL1 | LEVEL2 | LEVEL3 | LEVEL4 | LEVEL5 | LEVEL 6 | LEVEL 7 | LEVEL 8 | LEVEL 9 | LEVEL 10 |
123456 | test1 | 456789 | 789678 | 678956 | null | null | null | null | null | null | null |
245678 | Test2 | 456789 | 789678 | 564789 | 897654 | 678956 | null | null | null | null | |
345789 | Test3 | 456789 | 567890 | null | null | null | null | ||||
458905 | Test4 | 456789 | 789678 | 678956 | 563456 | 879654 | 789603 | 342567 | null | null | |
678956 | Test5 | 456789 | 789678 | null | null | null | |||||
789678 | Test6 | 456789 | null | null | null |
how can I get the end table with USERID 's from table1 replace LEVEL 1 which contains EMPLOYEEID and add new column after each LEVEL with name added?
EMPLOYEE ID | USERID | LEVEL 1 | NAME | LEVEL 2 | NAME | LEVEL3 | NAME | LEVEL 4 | NAME | LEVEL 5 | LEVEL 6 | LEVEL 7 | LEVEL 8 | LEVEL 9 | LEVEL 10 |
123456 | test1 | test100 | test67 | yupp3 | |||||||||||
245678 | Test2 | test100 | test67 | upoi1 | tryme1 | iamnew |
Solved! Go to Solution.