Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

doplear01
New Contributor III

diference between column in sames qvd's

we have several qvd's for the same procesess that should have the same amount of column but in some we have diferences. How can i make a process that check if this qvd have the same amount of column?

Thanks

4 Replies
MVP & Luminary
MVP & Luminary

Re: diference between column in sames qvd's

If qvd's have the same number of columns and the columns have the same name then Qlikview will automatically append the data to the same table. So you can simply load all the qvd's (using for example First 1 to limit the number of records loaded) and see which tables are created. You can then use the table viewer to inspect the tables.

Table1:

First 1

load * from *.qvd (qvd);


talk is cheap, supply exceeds demand
doplear01
New Contributor III

Re: diference between column in sames qvd's

In my case i have for example:

Qvd_1 : Column_A,Column_B,Column_C,Column_D

Qvd_2:  Column_A,Column_B,Column_C,Column_D,Column_E

how can i automatically (without viewing the table viewer) detect that the QVD_2 have one more column, because this qvd's should be the same

Luminary
Luminary

Re: diference between column in sames qvd's

Hi,

Use the CrossTable Statement and load at least NON NULL record across all the fields. This way you'll get all the Columns as Rows from both the QVD files. Then you can join them to the Table Name. And this makes easy to compare...

I hope it makes sense.

Good luck!

Cheers,

DV

www.QlikShare.com

Highlighted
doplear01
New Contributor III

Re: diference between column in sames qvd's

Thanks,

could you please show me with an example?