Fold child records into parent record - by listing associated part numbers (IDs)

[hellyars]

HI,

I want to consolidate references to a series of 1-N child records to a parent record by adding a list of associated part numbers (methods) to a base part number.  

BACKGROUND:

I have a build of material.  The lines consist of part numbers.  Some part numbers may have 1-N "method" associated with them -- like how to do something.  I have identified the relationships in the RLTNSHP and CODE fields.   1 = the Base P/N. 2 = 0-N Method P/N lines associated with a given Base P/N.  I have filled out all P/Ns that do not have a relationship.   The Method for a Base P/N is blank.  

START POINT

TIER	BASE	PN	MTHEOD	NAME	REV	RLTNSHP	CODE
1.1.4.1.11.4	12600125	12600125-015		WASHER,FLAT	C.7		1
1.1.4.1.11.4.1	12600041	12600041METHOD4	12600041METHOD4	PLATING AND COATING REQUIREMENTS	C.2	12600125-015	2
1.1.4.1.11.6	12602929	12602929-001		SUPPORT LEG,\	-0.4		1
1.1.4.1.11.6.1	12593834	12593834METHOD2	12593834METHOD2	TREATMENT AND FINISH REQUIREMENTS	E.4	12602929-001	2
1.1.4.1.11.6.2	12593834	12593834METHOD8	12593834METHOD8	TREATMENT AND FINISH REQUIREMENTS	E.3	12602929-001	2

GOAL/QUESTION:

I want to get rid of the METHOD P/N lines.  But, I need to add the 1-N METHOD P/Ns to the Base P/N  

DESIRED OUTCOME

TIER	BAE	P/N	METHOD(S)	PART NAME	REV	RLTNSHP	CODE
1.1.4.1.11.4	12600125	12600125-015	12600041METHOD4	WASHER,FLAT	C.7		1
1.1.4.1.11.6	12602929	12602929-001	12593834METHOD2,12593834METHOD8	SUPPORT LEG,\	-0.4		1

[markcurry · Accepted solution]

Hi @hellyars , have a look at the attached workflow, I think that gives you what you're looking for...

[vizAlter · Accepted solution]

Hi @hellyars — You may want to try this:

If this solves your issue please mark the answer as "Solved" with a Like, if not let me know!