Rename field from binary file

[fgirardin]

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 !

F

[ali_hijazi]

did you try
Rename field X to Y

of course after the binary load

[tresesco · Accepted solution]

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 .......;

....

[fgirardin]

Thank you both, it works perfectly