concatenate column values if the column values are equal.

[abhijith28]

Hi Qlik Experts @sunny_talwar  @Kushal_Chawda 

Need your help on the below scenario.

concatenate column values if the column values are equal.

Input Data

Output Data

Calculation condition = If the row has same Name, Across, Lat, Long the concatenate the Property values by '/'

For ex: ID=7,8,9 and  Name=David and Lat and Long are same, then the Property New is G/H/I and remaining values will be 0.

Attached the sample data.

Thanks,

[Taoufiq_Zarra]

@abhijith28  attached one proposition:

[Taoufiq_Zarra · Accepted solution]

or for the classement

[abhijith28]

Thanks @Taoufiq_Zarra 😊