Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
t1:
load
IF(wildmatch(Category, '*blue*'), 'Cold', Category)
FROM
[151654.xlsx]
(ooxml, embedded labels, table is [Sheet1]);
where Category is your column with Names