tejusarora Member

@atapia I ended up recreating the entire dataset. Starting to create backup files off domo.

You can use a group_concat formula within the group tile in ETL 2.0: Add the common data to the identifying column lists (such as user name, firstName, LastName) and then add these to the aggregated column by formula: MasterCourse: group_concat(MasterCourses_courseName Separator ' - ') LastLogin: Max(lastLogin)…

Hi Mark, SQL uses two single quotes to represent one in a string. so try using REPLACE(`Longitude`,'''','') This should definitely work @MarkSnodgrass

These are the only options available on the dataset page: @GrantSmith

The _BATCH_FILENAME_ only takes the parameter part. For instance, if the parameter is File Name Starts with America, then the _BATCH_FILENAME_ will only show America. I have a report with date in the column name such as America_0101202, and the date changes with the report. Is there a way to import these? Best, TJ

Doesn't work, it only reverts changes on the ETL not the dataset:

Hi Mark, I don't believe that's an option with Dropbox. What data source do you use? @MarkSnodgrass

Actually figured it out. It was right there in the FAQ's. Just need to check "Disable strict no data checking" in the settings tab of the campaign. This will allow the campaign to deliver even if one or more cards has all the data filtered out.

@Salmas i would try using datediff instead of minus (-) operand. That might work.

@mlevine_BRIT if you want to just schedule one single card and data this is possible without the campaigns app. Click on schedule as report and check the option that says include .csv attachment. This will schedule the card as well as the csv per your settings. Best, TJ

@Liliana If you have access to ETL 2.0 then you can add a formula tile with Date and combine with a couple of functions as shown below: Raw data: Thu Sep 02 00:00:00 GMT 2021 07:49 AM Output: 2021-09-02 07:49:00 (format in timestamp) Formula: timestamp(CONCAT(split_part(`Date`,' ',3), ' ', split_part(`Date`,' ',2), '…

@Ashleigh thanks for your response. This is what I finally ended up using. Was just curious if there was another way within filter :D @GrantSmith that will only keep john doe for '1/1/2021'

In case you are still looking for a solution, MAGIC ETL 2.0 now allows for a group_Concat functionality. So just add a group function and add group_concat on the column you want to merge. Best, TJ

I tried and tested out a few scenarios and the results have nothing to do with additional columns in your table. I see couple of potential issues with your code. While you mentioned that error occurs when Question_max_score is not equal to answer_value however your case statement is Question_max_score = answer_value…