Concat dublicate names in load script

[Anonymous]

Good day!

In my model i have two fields:

Id,

Name

Values in field Id is unique, but there may be several Names for one Id.

How in load script to concat Names for every Id, if count(Name)>0 for one Id?

Example:

Source:

Id Name

1 Name1_First

1 Name1_Second

2 Name2_First

Must be:

Id Name

1 Name1_First & Name1_Second

2 Name2_First

There're model and source file in attachment

Thanks.

[Kushal_Chawda · Accepted solution]

Load ID,

Concat(Name,' & ') as Name

From Source

group by ID;

[fvelascog72]

Hi,

Try this:

Table:

LOAD Id,

     Concat(Name, ' ') as "Name"

FROM ...

Group by Id;

[Anonymous]

Thanks! Good work

[Anonymous]

Thanks!!

[pratap6699]

new table: Load field1, concat(field2,’-’)as concatlist