topic Re: Concat dublicate names in load script in QlikView

Concat dublicate names in load script

Anonymous — Mon, 22 Jun 2015 12:53:37 GMT

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 — Mon, 22 Jun 2015 13:00:30 GMT

Load ID,

Concat(Name,' & ') as Name

From Source

group by ID;

fvelascog72 — Mon, 22 Jun 2015 13:01:33 GMT

Hi,

Try this:

Table:

LOAD Id,

Concat(Name, ' ') as "Name"

FROM ...

Group by Id;

Anonymous — Mon, 22 Jun 2015 13:15:14 GMT

Thanks! Good work

Anonymous — Mon, 22 Jun 2015 13:15:21 GMT

Thanks!!

pratap6699 — Mon, 22 Jun 2015 14:37:46 GMT

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