topic Re: Adding a specific entry to table in QlikView

Adding a specific entry to table

hibhardwaj — Wed, 14 Nov 2012 23:35:55 GMT

I am trying loading a rate file as below:

Rates:

LOAD

[Origin Country],

Rate as [Tariff Rate],

[Rate Currency],

[Origin City]&[Charge Code]&[Rate Unit] as Key

FROM

[Tariff.XLSX]

(ooxml, embedded labels, table is [local charges]);

Now after loading this file I want to add a specific Rate= $2 to a specific Charge Code= ABC. I want this rate to be applied to all the entries where the charge code is ABC irrespective of what other entries are.

How can I accomplish that?

Thanks for the help!

Re: Adding a specific entry to table

Thu, 15 Nov 2012 01:19:26 GMT

something like

if (Charge Code= 'ABC', 2,0) as [Specific Rate]

Re: Adding a specific entry to table

hibhardwaj — Thu, 15 Nov 2012 04:09:42 GMT

Hi Jasleen,

The problem is that the current data will never have Charge Code = ABC. I need to add ABC as a value of Charge Code manually. Can you suggest something for this?

Thanks for the help.

Re: Adding a specific entry to table

Thu, 15 Nov 2012 06:13:51 GMT

To introduce a value and create a field to hold it you can use 'ABC' as [Charge Code] in your script. Which means that the value 'ABC' is being assigned to [Charge Code].

Re: Adding a specific entry to table

jagan — Thu, 15 Nov 2012 07:15:02 GMT

Hi,

To add records to existing table you can use Concatenate option

Concatenate(ChargeCodeTableName)

LOAD

'ABC' as ChargeCode

AUTOGENERATE 1;

Hope this helps you.

Regards,

jagan.