Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
its_anandrjs

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

View solution in original post

4 Replies
its_anandrjs

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
Author

The following can be done in the script or the chart

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

Anonymous
Not applicable
Author

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
Author

Thank you all..