Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Concat Fields separated by '|' symbol

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

1 Solution

Accepted Solutions

Re: Concat Fields separated by '|' symbol

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

4 Replies

Re: Concat Fields separated by '|' symbol

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

Not applicable

Re: Concat Fields separated by '|' symbol

The following can be done in the script or the chart

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

Highlighted
Partner
Partner

Re: Concat Fields separated by '|' symbol

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?


Not applicable

Re: Concat Fields separated by '|' symbol

Thank you all..