Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a question about load of qvd data.
There is some application that loads data from qvd, and it throws an error if the qvds do not have same columns.
My question is: is there a way to check if the all qvds are in same format? Some kind of loop? I dont know
Thank you in advance
Easiest way is download "QVD Dictionary V2" from the below link
Downloads - Rob Wunderlich Qlikview Consulting
You can mention the location of your qvds and reload the qvd it will give u all the analysis on the qvds.
Perhaps you are loading multiple qvds and want them to be concatenated(prefereably 'auto'). If so, the tables with not-all-common-fields could be joined too with a force concatenation method by using 'CONCATENATE' keyword.
Hello,
I meant more like, they should be all the same, but for some reason (Lets say, the SAP was down, or some data source was not available) the creation of qvd will not be successful.
Example:
QVD1: Column1, Column2
QVD2: Column3, Column4
QVD3: Column1, Column2
I want to check, if all of them are having the Column1 and Column2?
Easiest way is download "QVD Dictionary V2" by Rob Wunderlich..
Several ways would be there. One could be somethiing like:
ConcatenatedT:
Load * From <qdv1>;
Concatenate
Load * From <qvd2>;
concatenate
Load * From <qvd3>;
If NoOfFields('ConcatenatedT')=2 Then
Trace 'Fields are common'
Else
Trace 'Not common'
Try Error Handling,
You would be able to resolve and automate this with that, Refer to this post.
http://businessintelligenceassistance.wordpress.com/2014/07/08/error-handling-in-qlikview/