Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
a. Happy Christmas
b. I thought I would quickly "do a favour" and load some data into Qlikview but:
the file has 4 sheets - they should all have the same column headings but they don't - I can fix this...
I created the 4 qvd files. average of 24,000 rows each.
I saved the files with the names: Rpt1516.qvd, Rtp1415.qvd, Rpt1314.qvd, Rpt1213.qvd
thinking I could then load * from Rpt*.qvd.
All goes well - seems to load very quickly but then the "close" button does not work - just hangs ...
Any thoughts?
I will read them on Wednesday after holidays
Jo
Because your tables haven't exactly the same datastructure they won't be automatically concatenated else you get 4 different tables which probably share a lot of common fields which cause multiple synthetic keys - which needs a lot of time and resources to be calculated - on your system hangs on them.
In this cases you need to clean/prepare your sources or you need a different load-approach by removing the wildcard-load with a filelist-loop in which you could force a concatenation (and if necessary doing a lot of further checkings or adjustments). See here a very easy example of what is meant: Re: In context of For Each ... FileList(), how to make NoConcatenate.
- Marcus
Which close button you are referring? Can you send screen shot of that close option
Because your tables haven't exactly the same datastructure they won't be automatically concatenated else you get 4 different tables which probably share a lot of common fields which cause multiple synthetic keys - which needs a lot of time and resources to be calculated - on your system hangs on them.
In this cases you need to clean/prepare your sources or you need a different load-approach by removing the wildcard-load with a filelist-loop in which you could force a concatenation (and if necessary doing a lot of further checkings or adjustments). See here a very easy example of what is meant: Re: In context of For Each ... FileList(), how to make NoConcatenate.
- Marcus
No limit. As Marcus says, simply loading them will make a mess. Use this method instead:
Data:
LOAD 0 As SomeField Autogenerate 0;
Concatenate(Data)
LOAD * From Rpt*.qvd (qvd);
Pick an arbitrary field from data and replace 'SomeField' with the name of that field - then there will be nothing to clean up.
To add point ..
you could add the QUALIFY * key world and UNQUALIFY the fields you want to link
Hi Marcus i am sorry but I cannot do a Correct answer - question answered from this screen??? It is not available anywhere I can see!
J