Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

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.

1 Solution

Accepted Solutions
Not applicable

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

Load

Column1 &  '|' & Column2 as MegedColumn

7 Replies
Not applicable

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

Load

Column1 &  '|' & Column2 as MegedColumn

Not applicable

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

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

Not applicable

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

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

Not applicable

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

yes

Load

Column1 & Column2 as MegedColumn

Not applicable

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

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

Not applicable

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

How can I insert an delimiter?

data & "|" & data    didn't work

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

use single quotes for string constants:

data1 & '|' & data2

Community Browser