topic Re: Error In Script? in QlikView

Error In Script?

Anonymous — Mon, 10 Aug 2015 16:58:10 GMT

Hi All,

QVD's are not being generated for few tables with the below script.

Ex: I have following tables

Table_2014,

Table_2014_1,

Table_2015_2,

Table_2015_6 ..of these.. only few tables are getting stored to qvd's sometimes the 1st and 3rd gets loaded, and sometimes 2nd and 3rd table, but not all the tables.

this is wat i have written....

FOR i=0 to NoOfTables()-1

LET vTabName=TableName(0);

STORE [$(vTabName)] into \\QVDpath\$(vTabName).qvd (qvd);

DROP Table [$(vTabName)];

NEXT i

Is there any problem with tables naming convention...

John

Re: Error In Script?

Anonymous — Mon, 10 Aug 2015 17:09:20 GMT

i do not know which table "Tablename(0)" is referencing as you drop this table after

what does next tablename(0) is getting?

as I understood Tablename(x) and NoOfTables() references to the previous loaded tables

so i would try: LET vTabName=TableName(i);

Re: Error In Script?

Anonymous — Mon, 10 Aug 2015 17:18:14 GMT

I tried Wat u mentioned Rudolf, I am getting error at the store statement.

Re: Error In Script?

swuehl — Mon, 10 Aug 2015 17:25:31 GMT

Do you have the same tables on every reload? And you get different number of tables stored with the same script?

Do you apply some conditional control script logic that may lead to removing / autoconcatenating tables on one reload but not on the other?

Have you tried adding some TRACE statements to track the number and names of all tables?

Re: Error In Script?

Anonymous — Mon, 10 Aug 2015 17:28:34 GMT

Hi.

I had some issues in the past with regards to Set and Let in a for loop.

Try using Set vTableName =....

alternatively you are going to have to pre-create a list of table names and then do a peek in your for loop. not as fast but you might need to do it in an alternate method.

Gareth

Re: Error In Script?

Anonymous — Mon, 10 Aug 2015 17:31:27 GMT

Swuehl, most of the tables are similar only slight change in suffix of the table name. I'm using the same script it is giving different results and finally no I have not used Trace statement. And also there are no conditional control logic or anything ...like that.

Re: Error In Script?

Anonymous — Mon, 10 Aug 2015 18:01:42 GMT

Thanks Swuehl, I figured out the problem, there are 3 tables with same field names where all were auto concatenating.

Cud you please tell how to undo this autoconcatenation

Re: Error In Script?

jonas_rezende — Mon, 10 Aug 2015 18:03:50 GMT

Hi, johnlewis‌.

Verify the following:

If before of LOOP the tables that contain fields common are concatened implicity. Thus, reduce the number of table.
In TableName() function, use varible $(i). Example:

FOR i = 1 to NoofTables()

LET vTabName = TableName($(i)-1); //It is work only thus.

STORE [$(vTabName)] into [$(QVDpath)\$(vTabName).qvd] (qvd);

DROP TABLE vTabName;

FOR i;

Hope this helps!

Re: Error In Script?

Anonymous — Mon, 10 Aug 2015 18:14:25 GMT

Use Noconcatenate function:

For example:

If the field names and number is same in 2 or more tables them QlikView performs an automatic concatenation but it is possible to prevent this automatic concatenation by using NoConcatenate

Let us load the same tables as in Part1 i.e. Table Cust_1 and Cust_2. These tables have same set of fields so they should get concatenated but this time load them by using NoConcatenate

Table viewer shows 2 tables. Automatic concatenation was prevented by using NoConcatenate.

Re: Error In Script?

Anonymous — Mon, 10 Aug 2015 18:22:56 GMT

No Jonas, Its not working its throwing error

Re: Error In Script?

jonas_rezende — Mon, 10 Aug 2015 18:38:02 GMT

johnlewis‌

What is the error message?

Re: Error In Script?

Anonymous — Mon, 10 Aug 2015 19:59:38 GMT

error in store command...

Re: Error In Script?

jonas_rezende — Mon, 10 Aug 2015 20:14:01 GMT

Please, post your QVDPath as initialized variable, including, just like the line STORE and INTO.

Re: Error In Script?

sasiparupudi1 — Wed, 12 Aug 2015 20:02:08 GMT

your problem is with the drop table statement which is altering the count of NoOfTables() after each drop so your vTabname is getting null value in the loop

FOR i=0 to NoOfTables()-1

LET vTabName=TableName($(i));

STORE [$(vTabName)] into \\QVDpath\$(vTabName).qvd (qvd);

DROP Table [$(vTabName)];-----> remove it

NEXT i

HTH

Sasi

Re: Error In Script?

sasiparupudi1 — Wed, 12 Aug 2015 20:08:12 GMT

you could use the following script for dropping the tables

do while NoofTables()>0

LET vTabName = TableName(0);

DROP TABLE $(vTabName);

loop;

Re: Error In Script?

sasiparupudi1 — Thu, 13 Aug 2015 08:40:42 GMT

Have you managed to solve your problem?

Sasi

Re: Error In Script?

qlikviewwizard — Thu, 13 Aug 2015 10:54:25 GMT

‌hi ,

please select the correct, helpful answers and close the thread.

thank you.

Re: Error In Script?

Anonymous — Fri, 21 Aug 2015 17:39:24 GMT

Thanks Sasi, appreciate your suggestions and thanks qlik community for bringing wonderful people on to single platform.