When I load the data is there someway I can merge the columns and separate them with a delimiter?

[#1]

When I load the data is there someway I can merge the columns and separate them with a delimiter?  I would like to search the data inside of one list so the "or" statement applies.

[#2 · Accepted solution]

Load

Column1 &  '|' & Column2 as MegedColumn

[#3]

You can use Concat function on script and use a delimiter, Not sure if this is what you are looking for.

[#4]

Can I concat the data into one list without a delimiter?

[#5]

yes

Load

Column1 & Column2 as MegedColumn

[#6]

I did this in the LOAD script and "|" was not recognized

[#7]

How can I insert an delimiter?

data & "|" & data    didn't work

[MarcoWedel]

use single quotes for string constants:

data1 & '|' & data2