Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
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);
Thanks Kush!!..The solution works...