Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
samuel_brierley
Contributor

DONT join tables

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

1 Solution

Accepted Solutions
Not applicable

Re: DONT join tables

use noconcatenate between the tables.

Table1:

.

.

..

.

Noconcatenate

Table2:

.

.

.

..

Noconcatenate

Table3:

.

.

.

5 Replies
lukaspuschner
Contributor

Re: DONT join tables

use noconcatenate function

nirav_bhimani
Contributor III

Re: DONT join tables

Hi,

write NoConcatenate just above both the table.

Regards,

Nirav Bhimani

Not applicable

Re: DONT join tables

use noconcatenate between the tables.

Table1:

.

.

..

.

Noconcatenate

Table2:

.

.

.

..

Noconcatenate

Table3:

.

.

.

samuel_brierley
Contributor

Re: DONT join tables

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

thanls

Re: DONT join tables

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

Community Browser