Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Dears:
i use below formula
substring('business_unit_code',6,3) or substring(business_unit_code,6,3)
want to pick up information from one string atttached.(I hope to get MCC or MSL)
but not workable. i have no idea what's wrong.
Thank you for the help.
Hi,
My example is working well:
- The index starts at 0 and the to is excluded, thus substring("http",2,4) = "tp"
- In your example, I believe it needs to be substring(col,5,8);
- See the detail explanation of substring in this page, https://doc.dataiku.com/dss/latest/formula/index.html#array-functions
On the engine:
- In the recipe, below the run button, you have an icon with 3 cogs;
- Clicking on it enables you to select between the available engines in your instance.
- See this page for an explanation on the different engines, https://doc.dataiku.com/dss/latest/preparation/engines.html
I hope this helps.
Dear Sir:
noted with thanks. how to test the engine and please share me the training information for it.
thank you very much.
BTW, from your screenshot, the result should be "ttps" instead of "tp". if my understanding is correct?
Hi,
My example is working well:
- The index starts at 0 and the to is excluded, thus substring("http",2,4) = "tp"
- In your example, I believe it needs to be substring(col,5,8);
- See the detail explanation of substring in this page, https://doc.dataiku.com/dss/latest/formula/index.html#array-functions
On the engine:
- In the recipe, below the run button, you have an icon with 3 cogs;
- Clicking on it enables you to select between the available engines in your instance.
- See this page for an explanation on the different engines, https://doc.dataiku.com/dss/latest/preparation/engines.html
I hope this helps.
Dear๏ผ
Got it as the formula identification is different with excel's.
Noted with thanks.