Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Load
Column1 & '|' & Column2 as MegedColumn
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?
yes
Load
Column1 & Column2 as MegedColumn
I did this in the LOAD script and "|" was not recognized
How can I insert an delimiter?
data & "|" & data didn't work
use single quotes for string constants:
data1 & '|' & data2