Edit Dimension "Contain"

[#1]

Hello,

Please, someone knows how to edit in Dimensions the following:

I will like to name all the "Names" that contain "Blue" in the Word (for example) as " Cold". Is this posible?

Thanks a lot

Belén

[maxgro]

If I understand you want to replace Names with blue (red arrow) with Cold

If yes, the calculated dimension is in the red rectangle

=if(wildmatch(Names, '*blue*'), 'Cold', Names)

[robert_mika]

You can do that in Load statement as well:

t1:

load

IF(wildmatch(Category, '*blue*'), 'Cold', Category)

FROM

[151654.xlsx]

(ooxml, embedded labels, table is [Sheet1]);

where Category is your column with Names