topic Problem with Concat in QlikView

Problem with Concat

jagannalla — Fri, 22 Jun 2012 10:09:23 GMT

Hello,

I've data in my column as

Image

2011_1129_053645_981.bmp

2011_1129_053645_649.bmp

2011_1129_053645_314.bmp

2011_1129_053644_981.bmp

2011_1129_053636_338.bmp

2011_1129_053636_009.bmp

2011_1129_053635_666.bmp

2011_1129_053635_332.bmp

soon

- Around 1million rows of data. What i want is, in single variable i want to store this data seperating with comma. I'm trying with Concat function it won't works for me. this is the code i'm using.

One way is: in v1= Concat(Image,',')

in script

ResImage:

LOAD Concat(Image,',') as Image1

LET vPkImage=Peek('Image1',0,'ResImage');

Want i'm getting the variable is .bmp, ,.bmp i mean wrong data. What is the issue?

Re: Problem with Concat

swuehl — Fri, 22 Jun 2012 10:43:01 GMT

But it works using only a subset of your data (first 1000 rows), right?

I am not aware of any exact number for a size limit, but I assume that your problem might be due to just the large number of rows you want to concatenate and store in a variable.

Do you really need to concatenate all these data?

Re: Problem with Concat

jagannalla — Fri, 22 Jun 2012 11:26:45 GMT

Exactly , I need to concat all the data in single variable.

For example:

2011_1129_053645_981.bmp,2011_1129_053645_649.bmp,2011_1129_053645_314.bmp

- Why i need this b'coz i'm runing the macro code to copy all this images to another folder. I tried with getfieldselection but when i select All values it gives me ALL.