Anybody knows how to add a field with the table name?
Thanks a lot
Use Qualify in script;
Load A,B from x.csv;
Load A,B from y.csv;
The two tables x.csv and y.csv are joined only on A. Three fields will result: A, x.B, y.B.
Hope it helps
Actually, I need the table name in a field, like this:
and one of the fields, say Field1, has only the value 'Table1'
Load *, 'Table1' as Field1 from file.qvd;
D'oh! I didn't think in that
Thank you very much!
Retrieving data ...