topic Re: my script is failing why so in QlikView

my script is failing why so

Anonymous — Thu, 24 Mar 2016 20:18:42 GMT

Final:

Load*

Resident Temp1;

drop table Temp1;

RENAME Table Final to Main;

STORE Main into (qvd);

T1:

Load *

FROM

(qvd)

Where [Date] = '1/18/2016';

store T1 into (qvd);

drop Table T1;

exit script;

Re: my script is failing why so

sunny_talwar — Thu, 24 Mar 2016 20:20:32 GMT

What exact error are you getting?

Re: my script is failing why so

sunny_talwar — Thu, 24 Mar 2016 20:21:59 GMT

On a second look may be this:

Final:

NoConcatenate

Load *

Resident Temp1;

DROP Table Temp1;

RENAME Table Final to Main;

STORE Main into (qvd);

T1:

NoConcatenate

Load *

FROM

(qvd)

Where [Date] = '1/18/2016';

Store T1 into (qvd);

DROP Table T1;

Update: You need a NoConcatenate because you are doing a resident load without removing or adding any new fields and the name of fields are not changing. This leads to auto-concatenation to your previous table and the new table will never be created and cannot be Dropped or renamed.

Re: my script is failing why so

maxgro — Thu, 24 Mar 2016 20:23:12 GMT

add the bold

Final:

noconcatenate

Load*

Resident Temp1;

drop table Temp1;

RENAME Table Final to Main;

STORE Main into (qvd);

T1:

noconcatenate

Load *

FROM

(qvd)

Where [Date] = '1/18/2016';

store T1 into (qvd);

drop Table T1;

exit script;

Re: my script is failing why so

sunny_talwar — Thu, 24 Mar 2016 20:26:46 GMT

Although I would further fine tune your script by removing the renaming part:

Main:

NoConcatenate

Load *

Resident Temp1;

DROP Table Temp1;

STORE Main into (qvd);

T1:

NoConcatenate

Load *

FROM

(qvd)

Where [Date] = '1/18/2016';

Store T1 into (qvd);

DROP Table T1;

Re: my script is failing why so

Anonymous — Thu, 24 Mar 2016 20:32:29 GMT

Thanks guys