Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

my script is failing why so

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;

1 Solution

Accepted Solutions
sunny_talwar

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.

View solution in original post

5 Replies
sunny_talwar

What exact error are you getting?

sunny_talwar

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.

maxgro
MVP
MVP

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;

sunny_talwar

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;

Anonymous
Not applicable
Author

Thanks guys