topic Re: Concat field Values in QlikView

Concat field Values

Anonymous — Tue, 25 Aug 2015 05:30:23 GMT

Hi All,

I am having columns F1 in T1 and F2 in T2. The F1 will have the unique values and F2 will have more than one values for same F1 value.

T1:

[F1

]

T2:

[F1,F2

1,AA

1,BB

2,C

3,DD

3,EE

]

Expected O/P

[1,AA,BB

2,C

3,DD,EE]

Re: Concat field Values

kaushiknsolanki — Tue, 25 Aug 2015 05:38:27 GMT

Hi,

Try this.

T2:

Load * inline [

F1,F2

1,AA

1,BB

2,C

3,DD

3,EE

];

output:

Load F1,Concat(F2,',') as NewFIeld

Resident T2 Group by F1;

Regards,

Kaushik Solanki

Re: Concat field Values

Anonymous — Tue, 25 Aug 2015 05:41:00 GMT

Both are two different table and in my dashboard the data model is different. For your clarity I have used it.

Actually it is Pivot table,there I need to CONCAT the values against each F1 value

Re: Concat field Values

kaushiknsolanki — Tue, 25 Aug 2015 05:42:32 GMT

Hi,

Then you can use the

Concat(F2,',') as expression in pivot table.

If this doesnt work please share the sample data showing your issue.

Regards,

Kaushik Solanki

Re: Concat field Values

Kushal_Chawda — Tue, 25 Aug 2015 05:44:52 GMT

if you have F1 as Dimension in Pivot table, you can simply write expression as Concat(F2,',')

Re: Concat field Values

sasiparupudi1 — Tue, 25 Aug 2015 05:59:23 GMT

Try like this

T1:

load * Inline

[

];

left join(T1)

T2:

LOAD F1,Concat(F2,',') as F2

group by F1;

load * Inline

[

F1,F2

1,AA

1,BB

2,C

3,DD

3,EE

];

NoConcatenate

final:

LOAD F1,F2 Resident T1 where IsNull(F2)=0;

drop Table T1;

Re: Concat field Values

jagan — Tue, 25 Aug 2015 06:27:32 GMT

Hi,

Try like this

Dimension : F1

Expression: Concat(F2,',')

Hope this helps you.

Regards,

Jagan.