This topic is locked

Appending/merging/concatenating of identical fields

4/24/2007 11:58:42 AM
PHPRunner General questions
V
vytb author

Hello,
I tried to use the new 'report' module to combine a number of fields by concatenating. However it maybe not the best way to do because of the following.
I'm having several files with the different number of the fields up to 100. All these fields are named according to the matrice table that has full 100 fields. When I query these tables to join them, the identically named fields are being added the table name and so the data is dispersed in the several fields that are very timeconsuming to concatenate or merge manually in STATA, MsExcel, or else. It appears to me that it would be easier to have these fields concatenated during queries? But how?
Vytautas