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?
use noconcatenate function
write NoConcatenate just above both the table.
use noconcatenate between the tables.
thanks that seems to have got it, i think anyway qlikview just died but im sure itl work
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.
Use Qualify *;
Load * FROM First;
Load * FROM Second;
Load * FORM Third;
Hope it helps
Retrieving data ...