Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

andreyfcdk91
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
kush141087
Not applicable

Re: Concat dublicate names in load script

Load ID,

Concat(Name,' & ') as Name

From Source

group by ID;

5 Replies
kush141087
Not applicable

Re: Concat dublicate names in load script

Load ID,

Concat(Name,' & ') as Name

From Source

group by ID;

fvelascog72
Not applicable

Re: Concat dublicate names in load script

Hi,

Try this:

Table:

LOAD Id,

     Concat(Name, ' ') as "Name"

FROM ...

Group by Id;

andreyfcdk91
Not applicable

Re: Concat dublicate names in load script

Thanks! Good work

andreyfcdk91
Not applicable

Re: Concat dublicate names in load script

Thanks!!

pratap6699
Not applicable

Re: Concat dublicate names in load script

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