Tring to split the values in a column into multiple rows using explode and I keep getting an error. I am not too familiar with the python tiles... The value in my row will be "A<br>B" and I want them to appear as two separate rows, one with A and one with B. Getting error: "00:00:01.817 domomagic: Version 0.3 00:00:01.819…
CASE WHEN `end_date__c` >= '1/01/2021' and `end_date__c` <= '12/31/2021' then `2021` else 0 end getting an error message Calculation Error : A column in this calculation did not exist.
Hi All, I was trying to have a hyperlink embedded inside a Domo Table/MegaTable and I used the following method. CONCAT('<a href="https://na132.salesforce.com/', `donation_link`, '" target="_blank">', 'Donation Link', '</a>') Now this is working perfectly on Domo but one major problem I'm facing is when I export the data,…
I am having difficulty understanding the case syntax while using magic ETL. In the current Example, I have a list of properties and coded them to display a text column of the region for each specific property. Unfortunately, there is no address line to be able to parse and use to make the regions so I'm hard-coding the…
Hi all, I have a dataset with 100+ columns. There are many columns with null values. I would like to remove all those columns without manually selecting those columns using the Select Columns tile on Magic ETL. Is there a way to do this?
Hi, Noticed some odd behaviour with a simple dataset I am pulling in from our db. From the column named Area onwards the data doesn't align to the column headers. e.g the AREA column should 1420 etc. It all needs shifting left. I have a feeling as I am selecting from two table and both have an ID column it can't work it…
Hi, I am trying to figure out how to pull 2 datasets together correctly. So, one dataset is Users and the other is Tickets. I want to connect Tickets to Users so I can have a single integer connected to a single user to show many tickets a specific individual has opened. Example: User_Name Number_Of_Tickets_Opened…
Is there a way, in analyzer or ETL, where we can only display one row for each unique value of a column corresponding to a key column? For example, I would want this: ID Num 1 4 1 4 1 5 2 4 2 5 2 6 3 6 3 7 3 7 to become this: ID Num 1 4 1 5 2 4 2 5 2 6 3 6 3 7
Hi guys, I have a view that once built has 112k rows. It is built from 7 datasets. Am I right in thinking once the view is built then it doesn't need to go back to the datasets and perform joins etc? I am seeing some very poor performance on the dashboard built from this view but the number of rows is quite low. The…
If a DataFusion has limitations on what can be edited after it's created, why would I use one instead of a Dataset View? When making certain changes to a DataFusion, you get the prompt that it is "no longer editable as a DataFusion", and must be saved as a Dataset View. Since Dataset Views are a lot more powerful (but…
It looks like you're new here. Sign in or register to get started.