qzqzqzqzqz Member

thanks all!! this was resolved; I used the formula in Data Flow.

thank you!

thank you!

Actual both worked although the functions do not show up in Beast Mode. thank you both!!!

thank you both! unfortunately my beastmode has neither substring_index or split_part. is there a reason I don't see the functions

Thank you. Unfortunately this has not yet been resolved. We are still working with support but we did have some success with the SQL partition however it runs 10 times slower.

Thank you all! @DavidChurchman could you please confirm if the following syntax looks right? REGEXP_REPLACE(`address`, "[^\\u0000-\\u007f]+", "")

With the SFMC REST Connector, below is a list of report visible to us:

thank you both for your quick responses!!

thank you both for your quick responses! I leveraged both of your advises and below is what I used eventually:

thank you both! I tried but the link does not work. I must have missed something. The original URL is: https://xyz.lightning.force.com/lightning/r/Opportunity/ABCDE/view What I would like to do is to make 'ABCDE' a variable. It is called 'Opportunity ID' in my dataset. I created the following beast mode but the link was…

thank you. my connector was set to append. I will change it to replace and back to append. thank you for your quick response!!