Add Field to Existing Data Table in Load Script

[CN]

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.

[skamath1 · Accepted solution]

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