November 04, 2008, 05:33 PM
KarCombining mutiple values into single value.
Hi,
I have input file with three fields
Cust Id, Name, State
How do I load into target table with all the three fields into one field.
Target table is Customer
Field CustInfo (Cust Id + Name + State)
I am using Data Migrator 7.4 on HP Unix.
Thanks
Kartik
November 05, 2008, 09:07 AM
PBrightwellI haven't used data migrator, but you should be able to do a define or a compute. The field size needs to be equal to the sum of the three input fields plus 2.
DEFINE FILE yourfile
CUSTINFO/A200=CUST_ID||(' '|NAME)||(' '|STATE);
END
November 06, 2008, 08:39 AM
Jessica BottoneResearch how to use the Transformation Calculator. How to do concatenation is listed with that.
Good luck.
Jessica Bottone