Rename field or alias commands not working with binary load

[#1]

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

[boorgura]

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.

[#3]

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?