topic Re: Variables are not ceated in script in QlikView

Variables are not ceated in script

christian77 — Fri, 04 Oct 2013 08:37:30 GMT

Hi:

I have this simple script:

LET vL.StartingDate = num(YearStart(today()));

LET vL.EndingDate = '20130131'; ////num(today());
Calendar:

LOAD
date(recno()+$(vL.StartingDate)-1,'YYYYMMDD') as SDate

autogenerate($(vL.EndingDate)-$(vL.StartingDate)+1);

for i = 0 to 1 ///NoOfRows(CalendarSAP)-1 /// Uncomment later. It works fine with NoOfRows

LET vL.LoopingDate = peek('SDate',$(i),'Calendar');
trace $(vL.LoopingDate);

MYTABLE:LOAD date,
     field1,
     field2FROM
[prueba.xls]
(biff, embedded labels, table is [Sheet1$])where date = $(vL.LoopingDate);
next i;
LET vL.Filas = NoOfRows(MYTABLE);   ////DON'T WORK. WHAT CAN I DO

LET vL.Columnas = NoOfRows(MYTABLE); ////DON'T WORK. WHAT CAN I DO

Store * from MYTABLE into MYTABLE.QVD;

//Drop table MYTABLE;

vL.Filas and vL.Columnas don't get created. How can I get that information?

Thank you.

Re: Variables are not ceated in script

Fri, 04 Oct 2013 08:43:42 GMT

Hi Christian

Try the following,

LET vL.Filas = NoOfRows('MYTABLE'); ////DON'T WORK. WHAT CAN I DO

LET vL.Columnas = NoOfRows('MYTABLE'); ////DON'T WORK. WHAT CAN I DO

Steve

Re: Variables are not ceated in script

jonathandienst — Fri, 04 Oct 2013 08:45:36 GMT

Use quotes:

LET vL.Filas = NoOfRows('MYTABLE');

Another issue - I don't know if this is directly related to your problem, but its possible your vL.EndinfDate is not being handled correctly. Rather use:

LET vL.EndingDate = Num(Date#('20130131', 'YYYYMMDD'));

Regards

Jonathan

Re: Re: Variables are not ceated in script

christian77 — Fri, 04 Oct 2013 09:07:58 GMT

Hi.

Thanks for answering.

I've tryed already wiht quotes. It does not work.

Regarding the format. Yes, I modified the script for you to test it. The format was fine before I commented, but that's not the issue.

I just want to know how many rows and fields has a certain table, assign those values to variables, and then drop the table. That way I can make a load proof and check the performance without having to check the QVD. I want to have it on the screen right after I load.

Thank again.

Re: Variables are not ceated in script

Fri, 04 Oct 2013 09:14:28 GMT

Christain

Just to confirm, you are using the single quotes like ' and not the double quotes like " ?

Steve

Re: Variables are not ceated in script

jonathandienst — Fri, 04 Oct 2013 09:20:14 GMT

Then it is likely that the table does not exist. If the Where clause returns no records, the table will not be created. You can test for the existence of a table by

LET vL.Filas = Alt(NoOfRows('MYTABLE'), 0);

This will return 0 if the table is empty or does not exist.

Regards

Jonathan

Re: Re: Variables are not ceated in script

christian77 — Fri, 04 Oct 2013 09:56:53 GMT

Hi:

let vL.Filas = NoOfRows ([O_ORCO_1] );
let vL.Filas2 = NoOfRows ('[O_ORCO_1]');
let vL.Filas3 = NoOfRows ("[O_ORCO_1]");
LET vL.Filas4 = Alt (NoOfRows([O_ORCO_1]), 0);
LET vL.Filas5 = Alt(NoOfRows('[O_ORCO_1]'), 0);

First 3 not created. Other 2 created with 0 value. It's curious since I haven't droped the table. Any workarround?

Re: Variables are not ceated in script

flipside — Fri, 04 Oct 2013 10:10:25 GMT

Hi Christian,

Only single quotes around the table name, and no square brackets. This should work.

flipside

Re: Re: Variables are not ceated in script

Fri, 04 Oct 2013 10:18:33 GMT

Christain

Do not use the square bracket [] when using the single quotes. This should then work.

Steve

Re: Variables are not ceated in script

flipside — Fri, 04 Oct 2013 10:30:11 GMT

Also, does your code work if you put single quotes in the WHERE clause in the loop section? ...

(biff, embedded labels, table is [Sheet1$])where date = '$(vL.LoopingDate)' ;

Re: Re: Variables are not ceated in script

christian77 — Fri, 04 Oct 2013 10:36:20 GMT

Halleluiah!!!!

I must thank you all. Since flipside was 8 minutes before I have to act in consequence.

World would be much easier if there were not underscores, and other special characters misused. I can’t change that name yet, cause I have to follow client naming system.

Once they gave me a password for an ftp with a slash on it ‘/’. I knew from the beginning it wasn’t going to work.

Thank you all once again.

Re: Re: Variables are not ceated in script

christian77 — Fri, 04 Oct 2013 10:40:23 GMT

Hi.

Eveything works fine now. Sometimes I have to change things before I post; Data Confidentiality. I'm not loading from excel, I'm loading from SAP, that's why I have to slice the loading.

Thanks again.