Rename a value in dimension and load only that value

[davyqliks]

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.

[davyqliks]

@PriyankaShivhare you helped with part of this code, are you able to assist if possible please?

Thank you in advance.

Daniel

[PriyankaShivhare · Accepted solution]

if(Len(Trim([Fibres])) > 0 and wildmatch(trim([Fibres]),
'Others1Others1Others1' ,
'Others1Others1' ,
'Others1'
)
, 'OtherMaterials' 
[Fibres]) as OtherMaterials,

Hope this helps!

Thanks

Priyanka

[davyqliks]

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