Add field with table name

[#1]

Hi,

Anybody knows how to add a field with the table name?

Thanks a lot 

Tania

[MayilVahanan]

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

[#3]

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

[MayilVahanan · Accepted solution]

Hi,

     Try likethis,

     Load *, 'Table1' as Field1 from file.qvd;

Hope it helps

[#5]

D'oh! I didn't think in that

Thank you very much!