topic Re: Create a new field in the LOAD-statement in QlikView

Create a new field in the LOAD-statement

mcornips — Fri, 15 May 2015 16:51:13 GMT

Dear all,

I want to create a new field in the load-statement which value should be equal to the name of the table. This is the table where the LOAD-statement refers to.

Regards,

Maurice

Re: Create a new field in the LOAD-statement

buzzy996 — Fri, 15 May 2015 16:58:11 GMT

whr is ur table?

may be,

tab3:

Load * Inline [

dim1,dim2

-4,0

-2,0.2

0,0.4

2,0.6

4,0.8

];

Tba2:

NoConcatenate load

dim1,

dim2,

'Tba2' as Tba2

Resident tab3;

drop table tab3

Re: Create a new field in the LOAD-statement

sunny_talwar — Fri, 15 May 2015 17:07:47 GMT

You can use TableName() function like this:

Table:

LOAD * INLINE [

Dim, Value

A, 10

B, 20

C, 10

];

Join(Table)

LOAD *,

TableName(0) as TableName

Resident Table;

Output:

Re: Create a new field in the LOAD-statement

mcornips — Fri, 15 May 2015 17:17:47 GMT

My Load statement is as follows:

LOAD Date,

Value1,

Value2;

SQL SELECT *

FROM `OS1`;

Now I want to create a new field (Tablename) which always shows the value OS1

Re: Create a new field in the LOAD-statement

sunny_talwar — Fri, 15 May 2015 17:21:45 GMT

Try this as buzzy996 mentioned

OS1:

LOAD Date,

Value1,

Value2,

'OS1' as Tablename;

SQL SELECT *

FROM `OS1`;

or use this for what I mentioned:

OS1:

LOAD Date,

Value1,

Value2;

SQL SELECT *

FROM `OS1`;

Join(OS1)

LOAD *,

TableName(0) as Tablename // 0 within parenthesis will depend on which table number it is in your load where first table = 0, second = 1, third = 2 and so on...

Resident OS1;

HTH

Best,

Sunny

Re: Create a new field in the LOAD-statement

mcornips — Fri, 15 May 2015 17:38:59 GMT

Thank you Sunny, this works.

But actually I would like to use the tablename of the source database.

Like this:

Substation:

LOAD Date,

Value1,

Value2,

'OS1' as Tablename;

SQL SELECT *

FROM `OS1`;

Re: Create a new field in the LOAD-statement

sunny_talwar — Fri, 15 May 2015 17:40:41 GMT

I am not sure if I know how to do that. Might be somebody else knows how to do it

Best,

Sunny

Re: Create a new field in the LOAD-statement

mcornips — Fri, 15 May 2015 17:49:30 GMT

Thank you, with your answers I can continue anyway.

Best,

Maurice

Re: Create a new field in the LOAD-statement

sunny_talwar — Fri, 15 May 2015 17:51:58 GMT

That's true , but I still hope that you find a better solution