Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Check if differrent qvds are loaded

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

Tags (1)
6 Replies
mjayachandran
Contributor II

Re: Check if differrent qvds are loaded

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.

MVP
MVP

Re: Check if differrent qvds are loaded

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.

Not applicable

Re: Check if differrent qvds are loaded

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
Contributor II

Re: Check if differrent qvds are loaded

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

MVP
MVP

Re: Check if differrent qvds are loaded

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'

Not applicable

Re: Check if differrent qvds are loaded

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/

Community Browser