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.
Column1 & '|' & Column2 as MegedColumn
I did this in the LOAD script and "|" was not recognized
You can use Concat function on script and use a delimiter, Not sure if this is what you are looking for.
Can I concat the data into one list without a delimiter?
Column1 & Column2 as MegedColumn
How can I insert an delimiter?
data & "|" & data didn't work
use single quotes for string constants:
data1 & '|' & data2
Retrieving data ...