topic Re: Rename field from binary file in QlikView

Rename field from binary file

fgirardin — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I use data from 3 differents sources: qvw file, SP and SQL

I need to rename the Key field from my QVW (KEY_Main_Item) as "Key" so I can link all the datas from these 3 sources

My script is as follow

___________________________________________

Binary [\\server1\QlikView\Data\Models\Data_Sales.qvw];

OLEDB CONNECT TO [********];

LET vT1=INPUT('ENTER TASK','INPUT BOX');

LOAD

"MAIN_KEY" as Key;

SQL SELECT *

FROM database.dbo."V_ITEMS"

Where Company = 'A';

ADD LOAD *;

SQL sp_RSM_project

@in_job_type = 1,

@in_param_varchar_1 = 'A',

@in_param_varchar_2 = 'f',

@in_param_varchar_3 = '$(vT1)';

_________________

Is there a way to rename a field loaded through a QVW file ?

Thank you for your help !

Re: Rename field from binary file

ali_hijazi — Thu, 11 Jan 2018 09:05:00 GMT

did you try
Rename field X to Y

of course after the binary load

Re: Rename field from binary file

tresB — Thu, 11 Jan 2018 09:10:59 GMT

Once you load the qvw using binary load, the data model gets into the source qvw. Hence you can rename the field immediately after binary load statement like:

Binary [\\server1\QlikView\Data\Models\Data_Sales.qvw];

Rename field KEY_Main_Item to Key;

OLEDB CONNECT TO .......;

....

Re: Rename field from binary file

fgirardin — Thu, 11 Jan 2018 10:38:15 GMT

Thank you both, it works perfectly