topic Rename field or alias commands not working with binary load in QlikView

Rename field or alias commands not working with binary load

Wed, 26 May 2010 20:20:46 GMT

Hi guys. I'm trying to integrate data models from two different QVW's. Both QVW's have a common ID field, but they're just named differently. After doing a binary load to bring in one of the data models, I want to rename the ID field to make it link with the second QVW. I tried using RENAME FIELD, as well as ALIAS, but neither seem to do anything. After reload the old ID name stayed the same. Any ideas? Thanks!

Eric

Rename field or alias commands not working with binary load

boorgura — Wed, 26 May 2010 20:26:20 GMT

Lets say the resident table name in the first data model is 'A'.

Then after binary loading the data model.

A_Fact:

Load field1 as new1,

field2,

field3

Resident A;

drop table A;

This should resolve your problem.

Rename field or alias commands not working with binary load

Wed, 26 May 2010 20:34:44 GMT

Yeah that would work, but I've got over a hundred fields in the data model that I would have to script line by line. I really don't want to do that. Is there another way?