Re^3: create a level csv

Note: OP has updated the post above with a much more detailed annotated explanation, so this answer may not make sense anymore.

Sorry for my slowness, but I didn't quite follow originally what you meant. I think I get it now. The first part of the line ("440Z0220-932") identifies a file. The duplicate lines associated with "440Z0220-932" are for each line within the file identified by "440Z0220-932". Is that right? So if you had only the following inputs:

# FILE #1: 0_IP_017.CSV (reduced to illustrate logic)

623Z5465-1001§other information
623Z5462-1003§other information

# FILE #2: 1_623Z5465-1001.CSV

623Z5465-1001§other information
623Z5465-1§other information
623Z5465-11§other information
CA623Z5465-1001§other information

# FILE #3: 1_623Z5462-1003.CSV

623Z5462-1003§Other information
623Z5468-1§Other information
623Z5468-9§Other information
623Z5468-7§Other information
623Z5468-5§Other information
CA623Z5462-1003§Other information
BACD40AC36B30§Other information
623Z5469-7§Other information
623Z5462-3§Other information
[download]

You would get the following output file?

1 623Z5465-1001§other information      #line in file #1 - ids file #2
2 623Z5465-1001§other information      #line in file #2
2 623Z5465-1§other information         #line in file #2
2 623Z5465-11§other information        #line in file #2
2 CA623Z5465-1001§other information    #line in file #2

1 623Z5462-1003§other information      #line in file #1 - ids file #3
2 623Z5462-1003§Other information      #line in file #3 
2 623Z5468-1§Other information         #line in file #3
2 623Z5468-9§Other information         #line in file #3
2 623Z5468-7§Other information         #line in file #3
2 623Z5468-5§Other information         #line in file #3
2 CA623Z5462-1003§Other information    #line in file #3
2 BACD40AC36B30§Other information      #line in file #3
2 623Z5469-7§Other information         #line in file #3
2 623Z5462-3§Other information
[download]

Best, beth

Update: finally got what OP meant and updated accordingly. The striken portion is below.

This is much better, but it still isn't clear why, for example, the output has two lines with "440Z0220-932":

0 440Z0220-932§other information 1 440Z0220-932§other information
[download]

but only one of your sample input files (0_IP_017.CSV) has a line with "440Z0220-932" in it.

Nor is it clear how you are defining that something is a node and what node number (0,1,2) to attach to it. For example, why is "440Z0220-932" assigned both 0 and 1 when it is only in the one non-"leaf" file? This doesn't seem consistent with your explanation above (at least to me).

Perhaps you could give us a very small set of short input files and an output file with just a few sample lines and then explain (in words) the reasons why you assigned 0,1, or 2 to each of the output lines.

Comment on Re^3: create a level csv Select or Download Code