Try this
Table:
LOAD * INLINE [
ID, Subid, Area
111, 1,
222, 1,
333, 2, IND
333, 3, PAK
333, 4,
333, 5, AUS
];
Left Join (Table)
LOAD ID,
Concat(DISTINCT Area, '/', -Subid) as Output
Resident Table
Group By ID;or
Table:
LOAD * INLINE [
ID, Subid, Area
111, 1,
222, 1,
333, 2, IND
333, 3, PAK
333, 4,
333, 5, AUS
];
Left Join (Table)
LOAD ID,
Concat(Area, '/', -Subid) as Output
Resident Table
Group By ID;
