renaming a value in the field while loading the data

[Anonymous]

Hi,

I have a field 'Brands' in my source data. I've loaded the field in my model:

Load

[Brands]

...

I'd like to rename one particular value in this field while loading the data. I'd like to rename 'Total' into 'All Market'. How can I do it in the script?

Thank you in advance,

Larisa

[maxgro · Accepted solution]

load

     .....,

     if(Brands='Total', 'All Market', Brands) as Brands,

     .....

[swuehl]

LOAD

     if([Brands]='Total','All Market', [Brands]) AS [Brands],

...

For a more sustainable solution, you can also look into a MAPPING solution.

[Anonymous]

Thank you!