Add Field to Existing Data Table in Load Script

CN — Thu, 28 Feb 2019 16:29:18 GMT

I have a data table in my load script that contains a field, [City]. I want to add a NEW field to the table, [Region].

[Region] does not currently exist and will need hard-coding to group the cities listed in the [City] field into specific regions in the new [Region] field.

EXAMPLE:

[Region] = ('Americas North', 'Eurasia', 'Australasia', 'LATAM', 'China')

[City] = ('Milwaukee', 'New York', 'Brisbane', 'London', etc...)

In the example, above, I would group 'Milwaukee' and 'New York' under "Americas North" in the Region field. That way my cities are grouped by region. This way I'm able to show metrics for a region, not limited to a city, or having to manually filter on all applicable cities.

Any script syntax help appreciated.

Re: Add Field to Existing Data Table in Load Script

skamath1 — Thu, 28 Feb 2019 16:48:55 GMT

A quick option would add an inline table with the following script.

You can add additional lines to each city and its region. Make sure the city field name is associated correctly to your existing field.

Regions:

LOAD * Inline
[City, Region
Milwaukee,Americas North
New York,Americas North
Brisbane,Australasia
London,Eurasia
];

topic Re: Add Field to Existing Data Table in Load Script in QlikView

Add Field to Existing Data Table in Load Script

Re: Add Field to Existing Data Table in Load Script