Merge/Join: Adding Data to 2 existing files?
-
How can we map a Source File to a Target File...and while transferring data , how can we Transform the source data as desired and then write to the target File. Example
Source File has 2 Column
------------------------
First Name and Last Name
Target File has 3 Column
-------------------------
First Name , Last Name and Age.
I want to Move the data from Source File to Target File (Already has Some Data) and Add age value to name of the person coming from the source.
I would appreciate , if somebody can help me do that....
Thanks -
1 Comment
-
Hans - The answer to this depends on the pattern data in the two files...
If the Source and Target files already contain mostly the same values for First Name and Last Name, then in DataManager import both files using File Source Blocks, then Merge the two files with 2 join criteria (both First Name and Last Name) to give you one Result file with the existing values in the Age field preserved, and any mis-matches on First/Last names left over.
You will still have to add the missing Ages to the Result file...
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.