topic issue with multiple 'concatenate's (for incremental loading) in QlikView

issue with multiple 'concatenate's (for incremental loading)

Thu, 13 Jan 2011 00:44:55 GMT

Hi guys,

I have two tables and two qvds (say table1, table2 and qvd1,qvd2)

I am trying to concatenate the tables with respective qvds

ex:

table1

concatenate

qvd1

and

table2

concatenate

qvd2

But my problem is only first concatenate is working. The second concatenate, instead of concatenating (or appending), it is replacing the qvd2 with the table2 data. I thought there could be something wrong with the second concatenate statement. But when I swapped the statements like

table2

concatenate

qvd2

and

table1

concatenate

qvd1.

Now the table2 and qvd2 concatenate is working fine but not the other one.

So I want to ask if anybody has tried using multiple concatenate statements and has anybody faced this kind of issue. Does anyone have a solution?

Thanks in advance

issue with multiple 'concatenate's (for incremental loading)

johnw — Thu, 13 Jan 2011 00:51:08 GMT

I don't know what the problem is. However, I ALWAYS specify which table I wish to concatenate to in order to help avoid problems. So for instance:

Table1:
LOAD some fields
FROM wherever;
CONCATENATE (Table1)
LOAD some fields
FROM something.qvd;

Table2:
LOAD some more fields
FROM somewhere;
CONCATENATE (Table2)
LOAD some more fields
FROM somethingelse.qvd;

issue with multiple 'concatenate's (for incremental loading)

Thu, 13 Jan 2011 00:58:03 GMT

Hi John, Thanks for the reply. I tried specifying the name. It did not work though.

issue with multiple 'concatenate's (for incremental loading)

johnw — Thu, 13 Jan 2011 02:05:57 GMT

I'm not sure, then. Can you post the script?

issue with multiple 'concatenate's (for incremental loading)

Thu, 13 Jan 2011 07:05:34 GMT

I agreed wit Mr Jhon.........

I think there is some mistake from your side at script level.

you should share the sample qvw application

issue with multiple 'concatenate's (for incremental loading)

Fri, 14 Jan 2011 18:29:54 GMT

oops.....that was my bad. i was using same field for both the tables and qvds and that was the reason for the wrong results. thanks anyways guys for responding.

Re: issue with multiple 'concatenate's (for incremental loading)

dmohanty — Mon, 28 Jan 2013 19:51:02 GMT

Hi John,

Can you please help out in this case:

I have to concatenate the QVDs from different folders. But the problem is that, when the QVDs from 2nd folder are coming, they are replacing the QVDs generated from 1st folder. My aim is to concatenate the QVDs from both the folders. Please suggest. Do I need to mention CONCATENATE somewhere?

Below is my code:

set errormode = 0;

let qvdpath = 'C:\Users\DICKY\Desktop';

for each vPlant in '$(qvdpath)\MAP\' , '$(qvdpath)\HPG\'

for each qvd_file in FileList('$(vPlant)*')

let QVDName = subfield('$(qvd_file)','\',6);

$(QVDName):

load

FROM

$(vPlant)$(QVDName)

(qvd);

store $(QVDName) into C:\Users\DICKY\Desktop\Test QVDs\$(QVDName);

drop Tables $(QVDName);

EXIT Script;