Concat Fields separated by '|' symbol

[#1]

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

[its_anandrjs · Accepted solution]

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

[#3]

The following can be done in the script or the chart

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

[Anonymous]

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?

[#5]

Thank you all..