Hi,
I write for information.
I have a ETL, that at some point in a transformer stage makes formal checks on the data.
Data that fail these checks must be discarded.
I add some control fields in transformer.
Among these I'd like one that contains the field name for which I need to control.
Is there a way to save the name of the column in question.
Thanks
Save in some way name of column in transformer
Moderators: chulett, rschirm, roy
Drag and drop, choose Derivation substitution after highlighting all the columns that have the source columns that are being tested, perform a field to grab everything after the dot (.) and surround it with quotes.
Do the above if dealing with large number of columns, for a few, just hardcode the values yourself.
Not a fancy solution but it works.
Do the above if dealing with large number of columns, for a few, just hardcode the values yourself.
Not a fancy solution but it works.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do each of the checks in a separate stage variable. For each of these initialize a corresponding stage variable to contain the name of the column or columns that are the subject of the test. Use that on the output link that captures failed rows.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.