Join in the front End

[Saravanan_Desingh]

Hi,

I have tow tables.

Area	Mapping
Canada	N
China	N
France	Y
Germany	Y
India	Y
Italy	Y
Japan	N
UK	Y
USA	N

Country

Australia

Canada

China

France

Germany

India

Italy

Japan

USA

Expected output:

Country	Mapping
Australia
Canada	N
China	N
France	Y
Germany	Y
India	Y
Italy	Y
Japan	N
USA	N

This can be achieved thru LOAD script without any issue.

But how to achieve through Expression in a Chart?

Thought this is a sample data, in my real scenario, I have few similar requirements.

Few expressions, which didn't work for me:

Only({<Mapping=p({<Country=p(Area)>})>} Mapping)

Only({<Country=p(Area)>} Mapping)

Only({<Area=p({<Country=p(Area)>})>}Mapping)

[Digvijay_Singh]

May be this -

Area as dimension and expression as -

Only({<Area={$(=chr(39)&concat(Country,chr(39)&','&chr(39))&chr(39))}>}Mapping)