topic Re: DONT join tables in QlikView

DONT join tables

samuel_brierley — Fri, 02 May 2014 09:39:48 GMT

Hi all,

I have 3 spreadsheets that have identical fields.

when I load them into qlikview obviously qlikview automatically joins them to 1 table, how do i stop this?

thanks

Re: DONT join tables

lukaspuschner — Fri, 02 May 2014 09:41:41 GMT

use noconcatenate function

Re: DONT join tables

nirav_bhimani — Fri, 02 May 2014 09:42:05 GMT

Hi,

write NoConcatenate just above both the table.

Regards,

Nirav Bhimani

Re: DONT join tables

Fri, 02 May 2014 09:42:48 GMT

use noconcatenate between the tables.

Table1:

Noconcatenate

Table2:

Noconcatenate

Table3:

Re: DONT join tables

samuel_brierley — Fri, 02 May 2014 09:45:12 GMT

thanks that seems to have got it, i think anyway qlikview just died but im sure itl work

thanls

Re: DONT join tables

CELAMBARASAN — Fri, 02 May 2014 09:45:54 GMT

Yes by using NoConcatenate will stop forming a single table, but will create synthetic keys and link all the fields. Instead use Qualify before your load.

Example:

Use Qualify *;

Load * FROM First;

Load * FROM Second;

Load * FORM Third;

Hope it helps

Celambarasan