Need to populate locations time zone in locations table

[Esha5]

Hi Team,

In my  location table having location name, city and time zones fields etc..

But all locations showing empty 'Time Zone' , How to set locations time zone.

please help me on this task.

Thanks in Advances.

[Sai Kumar B]

Hi Esha,

1.) Gather TimeZone data in excel from your customer

2.) Prepare the transform map and import data into the location table by applying "coalesce" on location name

[Ankur Bawiskar]

Hi,

Is it drop down field?

Regards
Ankur

[Esha5]

Hi Ankur,

Yes, it is drop down field.

Thank you for response. 

[Ankur Bawiskar]

Hi,

So who will be providing the timezone values?

If customer is going to provide you can use Data source concept and use Excel or CSV file to update the choices

1) ensure you share the correct location names in excel

2) customer would fill the timezone column in excel with the exact choice value present on table

3) then you can perform data load and transform it

Regards
Ankur