transformations
Discussion List
-
Trim 2 characters from right side of string using WorkbenchI have a dataset that appends every day and I want to remove 2 characters (.0) from the right side …
-
Domo beastmode and pivot questionHello, I'm trying to automate a file to run calculation in DOMO on a card. In the attached I added…
-
Looking up values from secondary data source but for multiple columns in primary data sourceSo I'm having some trouble wrapping my head around a solution for this scenario in Magic ETL: -I ha…
-
Table vs SQL Data Flows and which functions does Domo not recognize? (I'm confused)Hi, My CSM informed us that window functions are enabled. I would like to write the following via E…
-
changing a name in ETLI have an employee name in my raw data shown as >>> last_name, First_name middle_initial D…
-
Getting a Sum of Values for X Days When There are Gaps in the DatesWe have our dataset of transactions for a large number of SKUs. Dataset is over 1 Million rows. We…
-
Workbench 5 Crashes w/ custom pluginHello Domo Experts, I am having problems trying to create a custom, transform, plugin for Workbench…
-
Creating a separate column in transforming data using magic ETLI am using formula function to add a column that gives out values based on certain condition. I am …
-
Convert DATETIME (UTC) to specific timezoneHello, Domosapiens! I have an interesting quandry. I have a data flow (using MagicETL - should I be…
-
Improve Dataflow EfficiencyHello, Domosapiens, I currently have a data flow that is taking 14 min or greater to run. The desi…
-
DataFlow Transform (i.e. Action) Types in API JSON dataMy question: What factors determine the type of a dataflow transform in the api JSON data (e.g. Gen…
-
Regards to transforming data prior to joining with another data set.Attached are 2 different samples of data. Both are in similar format, and have plenty of same colum…
-
Is there an alternative of distinct on for redshift?Hey, I am trying to build a dataflow using redshift but distinct on is not supported. It's a simp…
-
Do not Generate Output Table in transformation not availableHello, I'm looking how to not Generate an Output Table in a transformation ? I did not have thi…
-
4Green Lightening!When in dataflows, one would benefit greatly from seeing the lightening bolt on the transform GUI t…
-
1Magic ETL Errors and Sample DataWouldn't it be great if there was an error on a Dataflow (Magic ETL or MySQL) that the sample datas…
-
Pivoting data in data flows (Year over year || week over week)Hi, I have account information on one of my data sets like this: Registrations: Name D…