Check if differrent qvds are loaded

[#1]

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

[mjayachandran]

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.

[tresesco]

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.

[#4]

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?

[mjayachandran]

Easiest way is download "QVD Dictionary V2" by Rob Wunderlich..

[tresesco]

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'

[#7]

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/