Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Add field with table name

Hi,

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

Thanks a lot 

Tania

Tags (1)
1 Solution

Accepted Solutions

Re: Add field with table name

Hi,

     Try likethis,

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

Hope it helps

4 Replies

Re: Add field with table name

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

Not applicable

Re: Add field with table name

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

Re: Add field with table name

Hi,

     Try likethis,

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

Hope it helps

Not applicable

Re: Add field with table name

D'oh! I didn't think in that

Thank you very much!

Community Browser