Adding a specific entry to table

[hibhardwaj]

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!

~H

[#2]

something like

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

[hibhardwaj]

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.

~H

[#4]

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].

[jagan]

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.