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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Renaming binary load? Help

Hi everybody. I have a little question.

I have an app with 3 loaded tables from a ODBC. I can´t reload the app, because i dont have access to the server. Also, i have to do one binary load with another app to have access for some dates, etc.

My idea is make a binary load and store the tables into 3 qvd. But i have a problem, i have a syntetic table, and i dont know how to modify the names of the tables. Should i use qualify? is that possible with binary load?

Thank you all.

Cheers.

Labels (1)
4 Replies
Not applicable
Author

I´ve just done this.

QUALIFY *;

A:

LOAD *

RESIDENT presupuestos_items;

STORE A INTO ;

stigchel
Partner - Master
Partner - Master

For each of the apps do a binary load in a new qvw, this should give you the tables from the original app. Then do a resident load using these tables where you do the changes. After this you can drop the original tables and store the new ones into a qvd. After that you can load the qvd's as you like

Not applicable
Author

My code worked, i don't know how to close the thread.

Cheers.

stigchel
Partner - Master
Partner - Master

You can mark mine or your own answer as correct to close the thread, if you found my answer helpfull, you can mark it as such ( does not close the thread