Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Concat dublicate names in load script

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.

1 Solution

Accepted Solutions
Kushal_Chawda

Load ID,

Concat(Name,' & ') as Name

From Source

group by ID;

View solution in original post

5 Replies
Kushal_Chawda

Load ID,

Concat(Name,' & ') as Name

From Source

group by ID;

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Try this:

Table:

LOAD Id,

     Concat(Name, ' ') as "Name"

FROM ...

Group by Id;

Anonymous
Not applicable
Author

Thanks! Good work

Anonymous
Not applicable
Author

Thanks!!

pratap6699
Creator
Creator

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