This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am facing challenge in mapping my final data with other mapping Table. Can some one please help me getting the Desired output:
Mapping Table :
Based on mapping Table, I need to add three columns (L1 Member, L2 member and L3 member) on my existing data source and show their respective values .Now the tricky part here is to is to check individual Columns (ID 1,RC Level 1,ID 2,RC Level 2 and So on) respectively. For example :
When there is any value in
ID 1,RC Level 1 say $C and Corporate - L1 Member - SAM
ID 2,RC Level 2 say $CA and Corporate Audit - L2 Member - ALICE
ID 3,RC Level 3 say $CAA and Corporate Advisory - L2 Member - JESSICA
Point to be Noted :So here mapping table data should check each column one of the original data source one after the another and assigning the correct Value .For example in Row 1 Actual data has columns ID 1 and level and if ID1 has Value then their respective L1 will come,IF ID 2 is their then respective L2 will come (Provided the L1 is same for ID 1 and Level 1 is same Like SAM) and IF ID 3 is there their then respective L3 will come (Provided the L1 and L2 are same for ID 2 and Level 2 Like SAM and ALICE)
As you can see in the highlighted example - L3 Member is JOHN not JACKY
Attaching the dataset for your reference.
My alteryx Version : 2018.3
Please let me know the correct way to map . In my dataset there are roughly around 30 Million rows are data which needs to be mapped
Can you explain exactly why your row 3 is SAM, ALICE,JESSICA and not SAM, JOHN, JESSICA? The lookups here are $M-Managing Fee and $CAA-Corporate Advisory, neither of which have ALICE as a possible member.
I am extremely sorry for creating confusion. yes you are right, it should be sam Vince Jessica..while writing the output..i was making changes so that i can cover all possible scenarios but I think i missed some important points.$M is part of Level 2 so Vince will come .sorry for causing the unnecessary confusion .