Need Help

[Mahamed_Qlik]

Hi Guyes,

I have query:

I have two filed in my data mode named as OriginCity and DestinationCity

OriginCity
London
New York

DestinationCity
New York
London

I want to create the new field named as CityPair, If I will create like this:'

OriginCity&'-'&DestinationCity as CityPair then i will get the result like :

CityPair
London-NewYork
New York-London

Instead of this i will need only single row stating London-New York

Regards,

Mahamed

[Mahamed_Qlik]

Hi Sakir,

Perfect bro. It works.

Thank you so much

Regards,

Mahamed