Filter ranges of records in a file based on search strings

[jerome_rajan]

Dear All,

We have a file that serves as kind of a master and holds data that should go into two different target tables with completely different metadata. Our source file looks something like

Code: Select all

<Line1>
a,b,c,d
g,h,i,j
<line2>
1,2
3,4
5,6
<line3>
garbage
<line1>
f,g,h,k
<line2>
1,2
7,9
<line3>
garbage
<line1>
...and so on

The idea here is to pick data lying between <line1> and <line2> and load into one Target(say A) and data between <line2> and <line3> to another target(say B). The data between <line3> and <line1> should be ignored.

I've started by reading each line into a single column. I'm trying to use the Transformer Loop to identify and bifurcate the data into two different links based on the logic mentioned above.

While I try, can someone please assist me in the looping logic?

Thank you.

[chulett]

I don't see a need for any kind of 'looping' here, just stage variable(s) to tract the current target based on the tags seen and then appropriate constraints on the output links.