topic Concat Fields separated by '|' symbol in QlikView

Concat Fields separated by '|' symbol

Tue, 02 Dec 2014 12:30:48 GMT

Hello Everybody,

I want to have an object where three fields will be concatenated and separated by '|' symbol. After selecting this it’s corresponding will be displayed in a separate chart.

Suppose there are 3 fields Empname, EmpId, sal. I want these three fields will be concatenated separating by “|” symbol. The composite field values will be used to copy and paste to SP site.

Please advise.

Thanks In Advance

Sonali

Re: Concat Fields separated by '|' symbol

its_anandrjs — Tue, 02 Dec 2014 12:37:09 GMT

Try to write like in loadscript you can use it in the front end also

Load

Empname,

EmpId,

sal,

Empname&'|'&EmpId&'|'&sal as NewField

From Location;

Regards

Anand

Re: Concat Fields separated by '|' symbol

Tue, 02 Dec 2014 12:37:51 GMT

The following can be done in the script or the chart

[field 1] & '|' & [field 2] & '|' & [field 3]

Re: Concat Fields separated by '|' symbol

Anonymous — Tue, 02 Dec 2014 12:39:12 GMT

you can use in script to define a new field

Load

Empname & '|' & EmoId & '|' & sal as NewField

You can do the same with a variable.

Depends on what you need in the separate chart. Can you be more specific?

Re: Concat Fields separated by '|' symbol

Tue, 02 Dec 2014 13:20:06 GMT

Thank you all..