topic Check if differrent qvds are loaded in QlikView

Check if differrent qvds are loaded

Wed, 08 Oct 2014 06:32:57 GMT

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

Re: Check if differrent qvds are loaded

mjayachandran — Wed, 08 Oct 2014 06:37:45 GMT

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.

Re: Check if differrent qvds are loaded

tresB — Wed, 08 Oct 2014 06:38:33 GMT

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.

Re: Check if differrent qvds are loaded

Wed, 08 Oct 2014 06:53:15 GMT

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?

Re: Check if differrent qvds are loaded

mjayachandran — Wed, 08 Oct 2014 06:55:20 GMT

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

Re: Check if differrent qvds are loaded

tresB — Wed, 08 Oct 2014 07:03:42 GMT

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'

Re: Check if differrent qvds are loaded

Wed, 08 Oct 2014 07:26:55 GMT

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/