Hello, I need some help pulling out email addresses from a text string. My goal is to place these multiple emails listed in the 'Description' column in a separate column, where they'll be separated by ','. Is there way for the search to end before the Sent Date info? Thank you!
Hi, I am wondering if this might be a glitch or what might be causing this problem. I have an ETL that I am trying to edit. The only dataset it uses is the calendar dataset. I am able to run it by going to the dataflow, clicking the three dots, then Run. (See attachment if confused) However when I click edit etl, and…
If I have 2 datetime columns (StartDate & EndDate), how do I find the duration (mins) between the 2 using Beastmode? Example:
I am trying to link 2 datasets to show scheduled appointments and web traffic in the same visit. The goal is to show what, if any, correlation there may be for traffic to specific ad campaigns and appointments for their related services. When I use datafusion or etl join, it gets messy because the only matching data I have…
Hey, I'm trying to select week id base on the current day and I wrote below case statement. But I'm getting error in here. Can someone help? (CASE WHEN week_id <= ( CASE WHEN CURRENT_DATE() BETWEEN '2024-02-10' AND '2024-02-16' THEN 1 WHEN CURRENT_DATE() BETWEEN '2024-02-17' AND '2024-02-23' THEN 2 WHEN CURRENT_DATE()…
CASE WHEN D's % of AOR = MAX(D's % of AOR) THEN 1 ELSE 0 END Some how this is returning the total for the column. All values are returning a 1.
Is there any way for me to mass rename columns? Instead of going into the "Select Columns" tile and going down the list 1 by 1 can I copy paste a text file somewhere that will do this? In any other case I would be fine renaming, but right now my dataset has an output of almost 700 columns.
This seems to be similar to the thread located here, but a little more extensive as we're looking to create a table that would compare several months as opposed to just two. https://dojo.domo.com/t5/Card-Building/hello-how-to-compare-month-to-month-with-secondary-axis-in-card/m-p/38214#M5099. And it looks as if a table…
I want to filter out strings that contain letters in my ETL. e.g. Serial 112233 445566PN In the ETL Add Formula Column Name: IsInt CASE WHEN serialLIKE ('%[A-Z]%') THEN 0 ELSE 1 END EDIT CASE WHEN SERIAL~* ([a-z]) THEN 0 ELSE 1 END This is working for A-Z and is case insensitive. Next question, is how do I filter out other…
Please see above scenario. Those are quotes tied to a project. You can see that quote 90795(column D) is a first revision of quote 90439. My goal is to create a calculation that would show binary output as shown in column E. Basically check every 'Project Name' and if there is a revision to a quote (marked in column B),…
It looks like you're new here. Sign in or register to get started.