Employee Hierarchy match with different table

[bharatm]

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

[fmvizcaino]

Yes @danilang , I overcomplicated the problem and didn't follow what Confucius told us. hahahaha