Complex logic

[umamahes]

I have an input file

[ArndW]

This complex logic is too much for me. Could you please explain the rules in text as well?

[JeroenDmt]

You can use a stage variable in a transformer to hold the parent value.
If you define the stagevariable svParent as:

Code: Select all

if IsNull(indata.Col1) then indata.Col2 else svParent

The value of this variable will change if a new parent record is found, and stay the same if child records are found.

Then you can use this stage variable to load the first column in the output.

[JoshGeorge]

Also add the constraint NOT(IsNull(indata.Col1)) in transformer

[JeroenDmt]

Also add the constraint NOT(IsNull(indata.Col1)) in transformer

Oops, yes, that would be useful too

[ray.wurlod]

Is this multi-level? Would you need to generate complete hierarchies, such as 1 2 3 4 5 6 ? That would add a deal of complexity (recursion), but could be solve using a carefully-designed hashed file and the little-known WITHIN query.