DONT join tables

[samuel_brierley]

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

[lukaspuschner]

use noconcatenate function

[nirav_bhimani]

Hi,

write NoConcatenate just above both the table.

Regards,

Nirav Bhimani

[#4 · Accepted solution]

use noconcatenate between the tables.

Table1:

.

.

..

.

Noconcatenate

Table2:

.

.

.

..

Noconcatenate

Table3:

.

.

.

[samuel_brierley]

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

thanls

[CELAMBARASAN]

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