Mapping of two columns from different tables

[Anonymous]

Hi,

I have two sheets in the excel where it contains three diff tables like Sub Region, CountryName2, BR_Country

now if we select on BR_Country the values in this country should map/compare with the values in the CoutnryName2 and fetch the Sub Region associated with it.

Hope you understand the requirement

[jyothish8807]

Hi John,

can you share your other two sheets, because in this sheet there is only one filed and there should be a primary fileld along with BR_country field so that we can apply MAp or lookup.

Regards

KC

[kushalthakral]

Hi John

You can use mapping load with the table having Country and subregion and then while loading other region u can use applymap() function to get details of a particular BR_Country.\

Regards

Kushal Thakral

[#4]

hi

there is a single table in first sheet.

Could you share the complete excel file.

[sujeetsingh]

Use applymap()

[jyothish8807]

Hi John,

You dont have unique field in both the sheets, so i dont think you can do a map or lookup on this.

eg, in BR_Country: its Singapore

but in Sub Region:its Singapore sales

Regards

KC

[Anonymous]

bump

[Anonymous]

use this script:

LOAD SubRegion,

     upper(CountryName2) as CountryName2

FROM

[RegionReq.xlsx]

(ooxml, embedded labels, table is SubReg);

LOAD

BR_Country

,  BR_Country as CountryName2

FROM

[RegionReq.xlsx]

(ooxml, embedded labels, table is Main);

exit script;

[Anonymous]

thanks for responding

I was struck in the mid of the scenario can you suggest me the solution

Hoping help from your end

http://community.qlik.com/thread/135781