Add an additional Column

[alibd225]

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

[Anonymous]

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.

[alibd225]

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))

));

[sundarakumar]

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

[qlikmsg4u]

CrossTable(Name, Quantity, 3)

LOAD *,

'Value' as Field_Name

FROM

[Barisal.xls]

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

Remove(Col, Pos(Top, 1))

));

[Anonymous]

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))

));

[alibd225]

Thanks both but not working this script....

[sundarakumar]

Pls share a sample.

[kaushiknsolanki]

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

[Kushal_Chawda]

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;