Tranformer logic
Posted: Thu Oct 06, 2011 8:22 am
I have three fields node,node_level,path
which has values like below
node :A|G|J|H|B|I|C|E|
next_level:X|X|G|G|A|G|A|B|
Path:/X|/X|/X/G|/X/G|/X/A|/X/G|/X/A|/X/A/B|
ignore the pipe(|) in between the records for the three fields and the rest are the records
in the table.
If lets say the next_level expires I need to expire all the nodes in the below path.
So lets say G expires then G,J,H should be expired and If A expires then A,B,E should be expired.
I have a design to expire the beginning level but I need to find their nodes in all the levels based on the path and node from the next_level
please suggest the code which can be used in the transformer to find out the nodes.
which has values like below
node :A|G|J|H|B|I|C|E|
next_level:X|X|G|G|A|G|A|B|
Path:/X|/X|/X/G|/X/G|/X/A|/X/G|/X/A|/X/A/B|
ignore the pipe(|) in between the records for the three fields and the rest are the records
in the table.
If lets say the next_level expires I need to expire all the nodes in the below path.
So lets say G expires then G,J,H should be expired and If A expires then A,B,E should be expired.
I have a design to expire the beginning level but I need to find their nodes in all the levels based on the path and node from the next_level
please suggest the code which can be used in the transformer to find out the nodes.