I have an input text file with the following format:
I need to modify it to I need to modify it to be as follows:
any ideas ?
Are your Type Codes fixed to 5 types?
Something like this:
Message Shape contains your example:
Data Process Shape:
Add To Cache Shape:
7col Flat File profile has Enforce Unique on column ID Employee
Notice the Default values set on columns 3-7.
Second Map Shape:
First "Add Cached Data" executes lookup on ID Employee and column CODE TYPE 1 (which has the value CODE TYPE 1)
Second "Add Cached Data" executes lookup on ID Employee and CODE TYPE 2 (which has the value CODE TYPE 2)
You can guess the rest.
Thank you very much. Excellent help.
I'll try and let you know
Retrieving data ...