I need to feed data into the PowerPlay transformer; I have a flat file which is look like this
Parent | Child
A | B
B | C
B | D
C | E
E | F
and so on..
On my bottom level I should have 5000 records, but my problem is that every record got different number of parents. Every record has the same top parent but some of records may have 10 parents in between and some may have only 4. Is there any way to make transformer skip missing levels and post the record on to the end of hierarchy instead of creating [Blank] columns from level 4 to level 10?
And my next question is:
What is the way power play handle the files with the parent child logic where child might be a parent as well.
Thanks for your time.
Parent | Child
A | B
B | C
B | D
C | E
E | F
and so on..
On my bottom level I should have 5000 records, but my problem is that every record got different number of parents. Every record has the same top parent but some of records may have 10 parents in between and some may have only 4. Is there any way to make transformer skip missing levels and post the record on to the end of hierarchy instead of creating [Blank] columns from level 4 to level 10?
And my next question is:
What is the way power play handle the files with the parent child logic where child might be a parent as well.
Thanks for your time.