String of codes

[kunalswami]

Need a help to build the expected result shown in screen shot and also in attached file.

As we see in the Row number 3. We have ITEMCODE= 8PA2543YDNEWMOD2 and for Like Profile=8PA2543YDNEWMOD1 which has a like profile= 310006 in row number 2. so we need the expected result for 8PA2543YDNEWMOD2 as shown in Expected result.

As we see in the Row number 4. We have ITEMCODE= 8PA2543YDNEWMOD3 and for Like Profile=8PA2543YDNEWMOD2 which has a like profile= 8PA2543YDNEWMOD1 in row number 3 and which also has a like profile in row number 2 as 310006. so we need the expected result for 8PA2543YDNEWMOD3 as shown in result.

[flying008 · Accepted solution]

Hi, @kunalswami 

Please find the Hierarchy Macro in  gallery then follow below process.

Output
ITEMCODE	Current Component	New Component	Like Profile
8PA2543YDNEWMOD2	960139	300006ET	310006
8PA2543YDNEWMOD2	300198	300042	310006
8PA2543YDNEWMOD3	960139	300006ET	310006
8PA2543YDNEWMOD3	300198	300042	310006
8PA2543YDNEWMOD3	300017ET	123478	310006
8PA2543YDNEWMOD4	960139	300006ET	310006
8PA2543YDNEWMOD4	300198	300042	310006
8PA2543YDNEWMOD4	300017ET	123478	310006
8PA2543YDNEWMOD4	300014ET	2343657	310006

[kunalswami]

Could you please share the workflow?

[kunalswami]

Could you please share the macro link not able to find it in gallery?

[binu_acs · Accepted solution]

@kunalswami you can find the hierarchy macro here

https://community.alteryx.com/t5/Community-Gallery/Hierarchy-Generation-Macro/tac-p/881903#M109

[flying008]

Hi, @kunalswami 

As @binu_acs  said, you can got it. 

[kunalswami]

Thanks @flying008  and @binu_acs