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
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)
You can do that in Load statement as well:
IF(wildmatch(Category, '*blue*'), 'Cold', Category)
(ooxml, embedded labels, table is [Sheet1]);
where Category is your column with Names
Retrieving data ...