topic Re: Need to insert column with my value to existing table in QlikView

Need to insert column with my value to existing table

Anonymous — Thu, 30 Apr 2015 10:54:45 GMT

Hi Friends,

Need a small help.

I have a table. I would to insert a column and the value of this column has to be NA

May I know if this is possible.

Example:

Original Table:

Column 1 Column 2 Need Column 3

A 1 NA

B 2 NA

C 3 NA

D 4 NA

Re: Need to insert column with my value to existing table

sunny_talwar — Thu, 30 Apr 2015 10:57:00 GMT

Are you trying to do this in the script??? If yes then you can do like this:

Table:

LOAD [Column 1]

[Column 2]

'NA' as NeedColumn3

FROM yourSource;

Re: Need to insert column with my value to existing table

ashfaq_haseeb — Thu, 30 Apr 2015 10:59:45 GMT

Hi,

Try like this

Load *,'N/A' as Col3;

load * Inline

[

Col1,Col2

A,1

B,2

C,3

D,4

];

Regards

ASHFAQ

Re: Need to insert column with my value to existing table

Anonymous — Thu, 30 Apr 2015 11:00:28 GMT

No. I have data with Column 1 and Column 2.

I have imported this data inside QlikView. But I want a to have a Column 3 and it should say NA (NA is not the heading) the data for Column 3.

Re: Need to insert column with my value to existing table

sunny_talwar — Thu, 30 Apr 2015 11:03:35 GMT

NA isn't a heading it will be data within your third column.

Best,

Sunny

Re: Need to insert column with my value to existing table

vikramv — Thu, 30 Apr 2015 11:07:23 GMT

TempTabA:

LOAD * INLINE [

ID, Country,

1, Ind

2, Sri

3, Ban, c

];

TabA:

Load *,'NA' as Col3 Resident TempTabA;

Drop Table TempTabA;

Re: Need to insert column with my value to existing table

Ralf-Narfeldt — Thu, 30 Apr 2015 11:13:56 GMT

If it's just as simple as showing it in a table, without having any logic attached, create a Straight table with Column1 and Column2, then add an Expression 'NA' with Column3 as label.

No loading or scripting required.

Re: Need to insert column with my value to existing table

sunny_talwar — Thu, 30 Apr 2015 11:13:57 GMT

You mean Resident TempTabA:

TempTabA:

LOAD * INLINE [

ID, Country,

1, Ind

2, Sri

3, Ban, c

];

TabA:

Load *,'NA' as Col3 Resident TempTabA;

Drop Table TempTabA;

Re: Need to insert column with my value to existing table

Anonymous — Thu, 30 Apr 2015 11:52:34 GMT

Thanks guys.. I used an expression as NA for Column 3