-
Can I Create Variables in Beast Mode?
I'm trying to create a variable that I can reference a beast mode calculation, but it keeps on telling me "This calculation contained a syntax error". Is it not possible to create variables in Beast Mode? Or am I just messing up the syntax? I've tried: set @month=1 set @month:=1 select @month=1 select @month:=1 But none of…
-
Do MySQL dataflows support the use of the WITH clause?
I'm trying to use a WITH clause as outlined here: https://dev.mysql.com/doc/refman/8.0/en/with.html in one of my MySQL dataflows. But I keep getting this error: "The database reported a syntax error. You have an error in your SQL syntax" My (very simple) code is: WITH test AS (SELECT`EmaiName` FROM transform_data_2) SELECT…
-
How to stop dataflows that get stuck at Indexing step
Hi everyone, Every now and then I run into a dataflow that runs fine but gets stuck at the Indexing stage for an hour or two. These dataflows normally take only 5-15 minutes to run, and the next time they run they don't get stuck in the indexing stage. It seems to be a weird hiccup that happens at random. Is there any way…
-
Incorrect data when using Adobe Analytics connector
Hi all, I am trying to create an Adobe Analytics connector to report on page views across various pages on our website. The report type for all of the testing I have done is Intermediate - Custom. When I create a connector with only one dimension (page name), and one metric (page views), then the page views on each page…
-
Converting String to Date in Dataflow
Hi, I have a dataflow where I combine two data sources. source1 has a date field formatted MM/DD/YYYY, and source2 has a date field formatted YYYY-MM-DD - let's call them date1 and date2. source1 also has far more records than source2, so I'm trying to perform as many calculations as possible on source2 rather than…