How to Conacatenate field values based on another field.

[#1]

for example

EMPID National_id

1          10

2           10

3            20

4            20

5            20

6            30

All the EMPIDs should be in single field value based on the National_id.

Out Put should be like

EMPID   National_id

1/2          10

3/4/5        20

6              30

[tamilarasu · Accepted solution]

Try like below,

Load Concat(EMPID,'/') as EMPID, National_id Group by National_id;

LOAD * INLINE [

    EMPID, National_id

  1, 10

  2, 10

  3, 20

  4, 20

  5, 20

  6, 30];

[#3]

Thanks Nagaraj

The issue got resolved.