Requirement to change field names in tables using QVD and Concatenation

[#1]

Hi,

I have a table that creates a qvd file. the qvd file is reloaded daily.

However, I need to change the name of one of the field names of the daily file.

for example, field name is Country and CountryName = Ireland. I need to change the Country Name to England. The file is always going to have the country name Ireland.

Firstly I need to change it in the QVD file and then for the newly loaded files and also for the concatenation to the FACT table.

I know I need to use an IF statement, e.g

if(CountryName = 'Ireland', 'England', Country) as CountryName 

I need to know how to achieve this with preceding loads, as the field name loaded in is already in the QVD File, can I rename it here and then preced this?

Thanks,

Gregg

[jvitantonio]

Reload the QVD file like

t1:

Load

field1,

field2,

If(countryName = 'Irland', 'England') AS CountryName

From qvdfile.qvd

and store it again

Store t1 into yourfile.qvd (qvd);