how to insert values from a mapping file to load records

[sanjujeeboy]

Hi All,

i have a mapping file which has certain set of countries eg: US,UK,Germany etc.

now i am loading some records in another table  based on above countries

Eg: Load * where Country = US,UK,Germany

My requirement is whenever mapping file gets updated with new country(suppose Italy), The table should should pick up that country also  eg:(Load * where Country = US,UK,Germany,Italy).

How to achieve this.

@Kushal_Chawda @jagan 

[Kushal_Chawda · Accepted solution]

You can do something like below

Assuming Country field name is same in both table. If not then change the name of country field in mapping table as same as main table

Mapping_Country:
load distinct Country
FROM Maptable;

Main_table:
load *
FROM Table
where exists(Country);

[sanjujeeboy]

Thanks Kush!!..The solution works...