Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.

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