topic Partial rename using field name map in QlikView

Partial rename using field name map

gshockxcc — Sat, 19 Dec 2015 19:28:48 GMT

I've been searching the community, but can't seem to find a mapping related post that covers exactly this topic.

I want to load a QVD and do a partial rename on all the fields.

The fields are names like this FIELDNAME_Current.

I want to rename them all to FIELDNAME_Prior.

I've tried to use a For loop for this, and it only works when loading the fields from an Excel file. It doesn't seem to work when loading from a QVD.

Re: Partial rename using field name map

effinty2112 — Sat, 19 Dec 2015 20:31:01 GMT

Hi Kristan,

Have a look at this script.

After you've loaded from your qvd(s) this script will look for field names ending in '_Current' when it does find one it adds a rowto a mapping table that's used on the final line of the script. I've tested this on a qvd with 25 fields all named ..._Current and all are named ..._Prior in the resulting resident table.

For i = 0 to NoOfTables() - 1

TRACE Looking at table : $(vTableName);

Let vTableName = TableName($(i));

for k = 1 to NoOfFields('$(vTableName)')

Let vFieldName = FieldName($(k),'$(vTableName)');

if Right('$(vFieldName)',8) = '_Current' then

Let vNewFieldName = Left('$(vFieldName)',len('$(vFieldName)')-8) & '_Prior';

FieldNameMap:

Mapping

LOAD

'$(vFieldName)' as FromFieldName,

'$(vNewFieldName)' as ToFieldName

AutoGenerate 1;

end if;

RENAME Fields using FieldNameMap;

Re: Partial rename using field name map

gshockxcc — Mon, 21 Dec 2015 12:13:53 GMT

Andrew,

Thanks for your quick response, and for the help. Regards, - Kristan