topic Re: Same table being loaded twice in QlikView

Same table being loaded twice

Fri, 23 Aug 2013 18:47:21 GMT

Hello, all .

I cannot find the answer to this in the manual. Please tell me why the following code loads test_table_1 twice instead of test_table_1 and then test_table_2?

test_table_1:

sql select ...

...;

test_table_2:

sql select ...

...;

What am I missing? Many thanks in advance.

Re: t

mphekin12 — Fri, 23 Aug 2013 18:56:35 GMT

Kevin,

It looks like you are missing LOAD statements. Try this:

test_table_1:

Load

...

;

sql select ...

...;

test_table_2:

Load

...

;

sql select ...

...;

Re: Same table being loaded twice

Anonymous — Fri, 23 Aug 2013 19:01:47 GMT

Kevin,

Not enough information. And, it is unlikley that it has anyhting to do with the preceeding load. Can you provide a little more info? Maybe upload an example?

Regards,

Michael

Re: Same table being loaded twice

Fri, 23 Aug 2013 19:17:19 GMT

Kevin,

Would you please provide the complete load script?

Thanks,

Aji Paul.

Re: Same table being loaded twice

Gysbert_Wassenaar — Fri, 23 Aug 2013 19:26:38 GMT

If the two select statements return the same number of columns with the same names then the results of the second select statement are automatically added to the first table. That's the default behavior of Qlikview. If you don't want that you have to specify the noconcatenate keyword above the second select statement or use the Qualify keyword so the fieldnames are prefixed with the table name thus making them unique.

test_table_1:

sql select ...

...;

Noconcatenate // or Qualify * ;

test_table_2:

sql select ...

...;

Note, this will result in a big synthetic key and probably performance problems. It's better to concatenate the two results and create a field to store where the data came from:

test_table_1:

sql select ..., 'fromsource1' as Source

...;

sql select ..., 'fromsource2' as Source

...;

Re: Same table being loaded twice

Mon, 26 Aug 2013 13:44:09 GMT

Thanks G.W. That's what I needed. Still a little rusty as it has been a few years. Thanks again!

And thanks to others for replying also :-).