topic Re: Add an additional Column in QlikView

Add an additional Column

alibd225 — Tue, 18 Aug 2015 06:02:46 GMT

i need to add an additional column with static value. i loaded data from excel by using ETS

Re: Add an additional Column

Anonymous — Tue, 18 Aug 2015 18:07:41 GMT

The wizard helps you do a conditional copy of data from other columns.

If it is a static value, u should write it on your script directly.

Re: Add an additional Column

alibd225 — Wed, 19 Aug 2015 05:31:06 GMT

This my script. can you help me how i add a additional column ?

CrossTable(Name, Quantity, 3)

LOAD *

FROM

[Barisal.xls]

(biff, embedded labels, table is Sheet1$, filters(

Remove(Col, Pos(Top, 1))

));

Re: Add an additional Column

sundarakumar — Wed, 19 Aug 2015 10:11:42 GMT

CrossTable(Name, Quantity, 3)

LOAD *,

'Static_Value' as Static_field

FROM

[Barisal.xls]

(biff, embedded labels, table is Sheet1$, filters(

Remove(Col, Pos(Top, 1))

));

you can directly add the static field as shown above, if it is a numeric value single quotes is not mandatory.

Regards,

sundar

Re: Add an additional Column

qlikmsg4u — Wed, 19 Aug 2015 10:14:00 GMT

CrossTable(Name, Quantity, 3)

LOAD *,

'Value' as Field_Name

FROM

[Barisal.xls]

(biff, embedded labels, table is Sheet1$, filters(

Remove(Col, Pos(Top, 1))

));

Re: Add an additional Column

Anonymous — Wed, 19 Aug 2015 10:16:13 GMT

Hi Yakub,

You can create flag for assigning static value as below

CrossTable(Name, Quantity, 3)

LOAD *,

'Value' as Static_field

FROM

[Barisal.xls]

(biff, embedded labels, table is Sheet1$, filters(

Remove(Col, Pos(Top, 1))

));

Re: Add an additional Column

alibd225 — Wed, 19 Aug 2015 10:35:23 GMT

Thanks both but not working this script....

Re: Add an additional Column

sundarakumar — Wed, 19 Aug 2015 10:38:12 GMT

Pls share a sample.

Re: Add an additional Column

kaushiknsolanki — Wed, 19 Aug 2015 10:41:30 GMT

Hi,

Try this,

ABC:

CrossTable(Name, Quantity, 3)

LOAD *

FROM

[Barisal.xls]

(biff, embedded labels, table is Sheet1$, filters(

Remove(Col, Pos(Top, 1))

));

ABC1:

Load *,'Value' as New_Field Resident ABC;

Drop table ABC;

Regards,

Kaushik Solanki

Re: Add an additional Column

Kushal_Chawda — Wed, 19 Aug 2015 10:45:19 GMT

Try

Data:

CrossTable(Name, Quantity, 3)

LOAD *

FROM

[Barisal.xls]

(biff, embedded labels, table is Sheet1$, filters(

Remove(Col, Pos(Top, 1))

));

New:

noconcatenate

load *,

'Static_Value' as Flag

resident Data;

drop table Data;

Re: Add an additional Column

alibd225 — Wed, 19 Aug 2015 11:08:20 GMT

this type of script i used & worked but i need to add an additional column in cross table command

Re: Add an additional Column

Kushal_Chawda — Wed, 19 Aug 2015 11:12:43 GMT

Then first add the value and then do Cross table

Re: Add an additional Column

Anonymous — Wed, 19 Aug 2015 12:42:06 GMT

hi yakub,

please post crosstable script with fields listed instead of wildcard in script.