topic Add field with table name in QlikView

Add field with table name

Fri, 20 Jul 2012 14:03:35 GMT

Hi,

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

Thanks a lot

Tania

MayilVahanan — Fri, 20 Jul 2012 14:10:33 GMT

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

Fri, 20 Jul 2012 14:18:54 GMT

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 — Fri, 20 Jul 2012 14:24:31 GMT

Hi,

Try likethis,

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

Hope it helps

Fri, 20 Jul 2012 14:32:46 GMT

D'oh! I didn't think in that

Thank you very much!