Merge 2 files

mfauzim · Post by **mfauzim** » Mon Mar 27, 2006 1:37 pm

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

regards

Post by **DataMystic Support** » Thu Mar 30, 2006 9:28 am

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?