Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Anybody knows how to add a field with the table name?
Thanks a lot
Tania
Hi,
Try likethis,
Load *, 'Table1' as Field1 from file.qvd;
Hope it helps
Hi,
Use Qualify in script;
Qualify B;
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:
Table1:
Load
Field1,
Field2
From file.qvd
and one of the fields, say Field1, has only the value 'Table1'
Thank you
Hi,
Try likethis,
Load *, 'Table1' as Field1 from file.qvd;
Hope it helps
D'oh! I didn't think in that
Thank you very much!