Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

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

use noconcatenate between the tables.

Table1:

.

.

..

.

Noconcatenate

Table2:

.

.

.

..

Noconcatenate

Table3:

.

.

.

View solution in original post

5 Replies
lukaspuschner
Partner - Creator
Partner - Creator

use noconcatenate function

nirav_bhimani
Partner - Specialist
Partner - Specialist

Hi,

write NoConcatenate just above both the table.

Regards,

Nirav Bhimani

Not applicable

use noconcatenate between the tables.

Table1:

.

.

..

.

Noconcatenate

Table2:

.

.

.

..

Noconcatenate

Table3:

.

.

.

samuel_brierley
Creator
Creator
Author

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

thanls

CELAMBARASAN
Partner - Champion
Partner - Champion

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