DataMystic

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

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?