topic Re: Duplicates identical tables in QlikView

Duplicates identical tables

Anonymous — Tue, 03 Nov 2015 08:46:23 GMT

Hi,

I have a strange problem -

While I'm expecting of qlikview to automaticly concatenate the table creation that resides inside a loop it does NOT and just duplicates the tables.

Attaching is a screenshot of the loop and the tables schema.

Any suggestions?

Re: Duplicates identical tables

Anonymous — Tue, 03 Nov 2015 09:59:11 GMT

Create the table as an empty stub before the loop and then within the loop force the Concatenate().

Re: Duplicates identical tables

Anonymous — Tue, 03 Nov 2015 10:11:30 GMT

all right.

Thanks, I'll try that later on.

BTW - do you know WHY does this happen?

Re: Duplicates identical tables

rwunderlich — Tue, 03 Nov 2015 14:59:57 GMT

After the first right join, the table now has additional columns. The net Load loads only two fields so will not autoconcatenate. Do as Bill suggest, create a dummy table and force concatenate.

Re: Duplicates identical tables

Peter_Cammaert — Tue, 03 Nov 2015 15:39:13 GMT

Didn't see that one, thanks Rob.

Would it work if the script file first assembles the new segment and then performs a load that could autoconcatenate, like in:

FOR i = 1 to 28

LET ...;

TempInstallersXX:

LOAD Account_id RESIDENT Accounts;

RIGHT JOIN

LOAD Account_id,

Month(...) AS Month,

...

RESIDENT solar_ffield

WHERE ...

GROUP BY ...;

Lost_InstallersXX: // Will AUTOCONCATENATE?

LOAD * RESIDENT TempInstallerXX;

DROP Table TempInstallersXX;

NEXT i;

[Edit] Sorry, I thought I got a very simple version that does the same, only to realise that I can't get my head around the LOAD/RIGHT JOIN logic. What is it's purpose? It won't reduce the data loaded from solar_field.

Best,

Peter

Re: Duplicates identical tables

Anonymous — Tue, 03 Nov 2015 15:56:58 GMT

Hi Rob

I didn't understand your sentence of - " The net Load loads only two fields "

what is a net load?

Thanks