topic Re: Excel to qvd in QlikView

Excel to qvd

kris_vliegen — Mon, 15 Dec 2014 11:12:00 GMT

Hi All,

I've created a script that makes a Qvd out of an excel.

Sometimes the excel has no records. Now I would like to create the qvd only if there are records in the excel.

I've created the script to calculate the maximum rownumber.

Who can help me with this?

Regards Kris

StocksrowTemp:

Load

RowNo() as Row

resident Stocks;

NoConcatenate

Stocksrow:

Load

max(Row) as MaxRow

Resident StocksrowTemp;

drop table StocksrowTemp;

directory ..\03_QVD ;

If ( MaxRow > 0,

store

Stocks into Stocks.QVD);

Re: Excel to qvd

ali_hijazi — Mon, 15 Dec 2014 11:16:06 GMT

suppose your table is called My_Table

My_Table:

Load *

from path to excel file....

you can check the number of rows in this table:

if not isnull(NoOfRows('My_Table') and NoOfRows('My_Table') > 0 then

store My_Table into My_Table.qvd;

endif

Re: Excel to qvd

kris_vliegen — Mon, 15 Dec 2014 11:25:27 GMT

Hi Ali

Thanks for your responf.

I've created this script and it isn't working.

And as you can see there is an error in the script...

Re: Excel to qvd

Anonymous — Mon, 15 Dec 2014 11:48:45 GMT

Looks like you are missing a closing bracket on the IsNull function.

Re: Excel to qvd

Mon, 15 Dec 2014 11:49:15 GMT

You can't use not as part of the if statement. Also the isnull is missing a ) to close it out.

Try:

if isnull(NoOfRows('My_Table')) = 0 and NoOfRows('My_Table') > 0 then

store My_Table into My_Table.qvd;

endif

Re: Excel to qvd

its_anandrjs — Mon, 15 Dec 2014 11:52:33 GMT

Hi,

Try this way and load a if condition

Ex:-

if NoOfRows('TabA') > 0 then

STORE TabA into TabA.qvd;

ENDIF

In your example:-

if NoOfRows('Stocks') > 0 then

store My_Table into My_Table.qvd;

endif

Regards

Anand

Re: Excel to qvd

Mon, 15 Dec 2014 11:53:23 GMT

I thought IsNull can be one of two value 0 or -1. Therefore maybe the '>' you use not correct either.

Re: Excel to qvd

ali_hijazi — Mon, 15 Dec 2014 13:05:54 GMT

you miss the ) for the isnull function

Re: Excel to qvd

kris_vliegen — Mon, 15 Dec 2014 13:07:09 GMT

Thanks everyone. It is working fine now.

if NoOfRows('Stocks') > 0 then

store My_Table into My_Table.qvd;

endif