topic Re: Renaming binary load? Help in QlikView

Renaming binary load? Help

Wed, 22 Oct 2014 18:03:13 GMT

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.

Re: Renaming binary load? Help

Wed, 22 Oct 2014 18:26:06 GMT

I´ve just done this.

QUALIFY *;

LOAD *

RESIDENT presupuestos_items;

STORE A INTO ;

Re: Renaming binary load? Help

stigchel — Wed, 22 Oct 2014 18:27:45 GMT

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

Re: Renaming binary load? Help

Wed, 22 Oct 2014 18:32:43 GMT

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

Cheers.

Re: Renaming binary load? Help

stigchel — Wed, 22 Oct 2014 18:36:16 GMT

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