Merge 2 files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
Posts: 1
Joined: Mon Mar 27, 2006 1:34 pm

Merge 2 files

Post by mfauzim »

I have 2 files. File A is ther reference data with column id and name
file 2 is detail log data with date, id , etc

Can Textpipe merge these 2 files based on id and output into third file c with data, id , name( from file A) and other fields

User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Post by DataMystic Support »

This is best done with a database.

The way to do this in TextPipe would be to use a VBScript. This would load the entire File A into an associative array, and then supply the correct Name field data as the id field of File B was examined.

Does that help?
Post Reply