Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
From a dimension in the load i am trying to rename some values as another and then only load the renamed.
See the below effort.
if(Len(Trim([Fibres])) > 0 and wildmatch(trim([Fibres]),
'Others1Others1Others1' ,
'Others1Others1' ,
'Others1'
)
, Only('OtherMaterials'),
[Fibres]) as OtherMaterials,
I am trying to find these values:
'Others1Others1Others1' ,
'Others1Others1' ,
'Others1'
and then name as 'OtherMaterials' and then only load those values as the dimension [OtherMaterials]
I can confirm all is working other than ONLY loading the renamed as OtherMaterials.
Can anyone assist please?
Thank you in advance.
if(Len(Trim([Fibres])) > 0 and wildmatch(trim([Fibres]),
'Others1Others1Others1' ,
'Others1Others1' ,
'Others1'
)
, 'OtherMaterials'
[Fibres]) as OtherMaterials,
Hope this helps!
Thanks
Priyanka
@PriyankaShivhare you helped with part of this code, are you able to assist if possible please?
Thank you in advance.
Daniel
if(Len(Trim([Fibres])) > 0 and wildmatch(trim([Fibres]),
'Others1Others1Others1' ,
'Others1Others1' ,
'Others1'
)
, 'OtherMaterials'
[Fibres]) as OtherMaterials,
Hope this helps!
Thanks
Priyanka
Thanks Priyanka,
I tried this but it was not working then realised some other values were pulling from another table.
Thanks again so much for your help.
Daniel