Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use noconcatenate between the tables.
Table1:
.
.
..
.
Noconcatenate
Table2:
.
.
.
..
Noconcatenate
Table3:
.
.
.
use noconcatenate function
Hi,
write NoConcatenate just above both the table.
Regards,
Nirav Bhimani
use noconcatenate between the tables.
Table1:
.
.
..
.
Noconcatenate
Table2:
.
.
.
..
Noconcatenate
Table3:
.
.
.
thanks that seems to have got it, i think anyway qlikview just died but im sure itl work
thanls
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