HI, we're migrating from username sign in, to okta that uses email as user id. we have an existing user info data with user id as username (xfsgsbss) but we would have a new data with user id as email(fdhsvbsjsbsjsh@email.com). I want to be able to join both old and new data and make sure the right attributes goes to them,…
Hello! I know variations of this question have been asked in the forums but I haven't been able to find a solution that works for me. I have a column Project Name that contains Projects out of Financial Force that may contain an At-Risk ticket number, which is formatted as: AR-00000 i.e. literally "AR-" or "AR - " followed…
Hi, I'd like to create a re-useable calc that will filter out certain words or phrases that are found in a field. example: Closed Description field might have the words or phrases below which I do not want my cards to display those records. SPAM, N/A, Dup, Duplicate Thanks, Lisa
Can you convert Magic ETL into a SQL Script?
Hello, I'm attempting to perform a correlated subquery using an inequality as shown in the below example. SELECT a."Opportunity ID", a."Owner ID", a."Created Date", a."Close Date", a."Snapshot Date", a."Last Modified Date", a."Next Step", a."Competitor", a."Amount", a."Stage", (SELECT COUNT("Opportunity ID") FROM "pushes"…
Is there a way to save data and possibly append to it? Let me give an example. When I pull data from a database, I would like to pull data and when I pull data tomorrow I want the original data to still be there. So I want to be able to see user counts by region today, and then in a month I would still like to see what it…
I have 2 contact databases where I need to join them based on both phone number, name, and email. I am able to currently join on phone but the email part I am having an issue with. When trying to join on email it isn't working. What is the best way to join on email address and if possible where emails closely match?
I'm using this formula to calculate the average quarterly engagements SUM(Total Engagements) / COUNT(DISTINCT QUARTER(Date) ) When a marketing campaign data falls under full and partial quarters, however, this approach generates a skewed number. I need a way to test for and countthe number of full quarters that a campaign…
Hi everyone, I have a dataset which looks like the following: EmailRunning Latest VersionVersionfred@email.comYes2.1bob@email.comYes2.1angela@email.comNo1.0tran@email.comNo1.5 I would like to do the following: If someone is not running the latest version (Running Latest Version = No) then send an email to the person as an…
I have an ETL that's been running for over a year. I made some updates to it and now it will not run, despite the preview showing everything marked as green. The error message says "Saved but incomplete. Cannot be run until all actions are configured correctly." Can anyone advise on what might be going on here? I've…
It looks like you're new here. Sign in or register to get started.