Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);