Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
load
.....,
if(Brands='Total', 'All Market', Brands) as Brands,
.....
load
.....,
if(Brands='Total', 'All Market', Brands) as Brands,
.....
LOAD
if([Brands]='Total','All Market', [Brands]) AS [Brands],
...
For a more sustainable solution, you can also look into a MAPPING solution.
Thank you!