topic Change fields name from other file in QlikView

Change fields name from other file

jumiprado — Wed, 07 Nov 2018 13:04:24 GMT

Hello guys!

I have the following problem,

I have two csv files, one of them have the data and the other the name of fields, when i load the information qlikview show me this

LOAD @1,

@2,

@3,

@4,

@5,

@6,

@7,

@8,

@9,

@10,

@11

and i have to change each field with other file where i have the names of that fields, who can i do this rapidly?

thanks!

swuehl‌

stalwar1‌

Re: Change fields name from other file

prieper — Wed, 14 Nov 2018 08:47:30 GMT

an example might be helpful ...
aircode might be

Header: LOAD Header FROM Headerfile ...; // get data in structured format

Data: LOAD @1, @2 , etc FROM Datafile ...;// load the csv-table

FOR i = 0 TO NOOFROWS('Header') -1 // loop through the header-table
LET sFieldRead = '@' & i; // create a string matching with the fieldnames automatically provided in Data
LET sFieldWrite = PEEK('Header', i, 'Header'); // read the corresponding value
RENAME FIELD $(sFieldRead) TO $(sFieldWrite);
NEXT i

Peter

Re: Change fields name from other file

MarcoWedel — Thu, 15 Nov 2018 00:59:16 GMT

Hi,

you can create a mapping table from your field names and rename the fields using this mapping table:

hope this helps

regards

Marco

Re: Change fields name from other file

MarcoWedel — Thu, 15 Nov 2018 01:00:32 GMT

please post some sample data for both of your files to demonstrate
thanks
Marco

Re: Change fields name from other file

prieper — Thu, 15 Nov 2018 08:28:20 GMT

Marco's solution is better than mine ..