Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Combining mutiple values into single value.
Go
New
Search
Notify
Tools
Reply
  
Combining mutiple values into single value.
 Login/Join
 
Silver Member
posted
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
 
Posts: 43 | Registered: August 09, 2007Reply With QuoteReport This Post
Master
posted Hide Post
I 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


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Research how to use the Transformation Calculator. How to do concatenation is listed with that.

Good luck.

Jessica Bottone


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
 
Posts: 126 | Registered: January 18, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Combining mutiple values into single value.

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.