-
Dataflow failed
Hello all, I get the below error after running my dataflow. As this consists for multiple inputs, I haven't still been able to trace the exact field causing it. But I do have a formula tile with this calculation.. " Failed to convert value '-3--3-01' from type 'String' to type 'Date'. " Some days this data flow runs…
-
Append Output dataset help
Hello all, I have an Magic ETL (A) that with a output dataset - say OUTPUT_1. What I am looking for, is when every time I run the ETL, I need the output results to be appended. At the same time it should not create duplicate records. I created a new Magic ETL (B) with this OUTPUT_1 as input dataset and outputted to…
-
Question on Domo SQL syntax
Hello all, I am trying to do Magic Transform using SQL option. I have embedded a SQL query but it is erring as it is not compatible with Domo syntax. Appreciate your help in this regard. DATE_PART('WEEK',CAST(TO_CHAR(TO_DATE(TO_CHAR(PRODUCT_KEY),'YYYYMMDD'),'YYYY-MM-DD') AS DATE)) AS "SaleWeek",…
-
Aggregate and ETL question
Hello all, I have the below workflow in my Magic ETL. Just posting a sample version below. My question is - I have a ProductID that I join from both the data sources and then do a group by and output to a file. But I also need to know Total count of Product ID or row count from TEST spreadsheet source. Is there a way I…
-
Date format question
Hello all, I have a snowflake i/p data source. One of a column is a date field and it showing up as floating decimal in Domo. This field has value -3 (even in data source) if it is a null else it is a date.. As this is floating decimal type in domo, under configuration I changed to Date type. When I try to join with…
-
Multi-tab input
Hello, I have a input data set that is a multi-tab spreadsheet. I used File upload option to import that to Domo. When I am using this in Magic-ETL, I am unable to specify the tab that I need.. What is the way to specify the exact tab I referring to in that spreadsheet. I need to use different tabs for different joins in…
-
Number format
Hello all, I am trying to replace the Number format in Card/Dashboard. For example: Number is displayed as 21K but I need it to be full number with comma separator. Or 1.19K should be displayed as full number instead of 1191? I tried all ways but it does not seem to change the format. Can someone help me with this?
-
Restricting Dataflows
I am admin for my instance.. I have shared input datasets to a specific group with a role. But I notice that they automatically get all my dataflows access that include those above shared datasets and they are able to edit the dataflow as well. Is there a option to restrict the access of dataflows (ETLs) though those…
