transformations
Discussion List
-
Combining Rows of Data with a common attributeHi, I have a dataset which is product data cross multiple years. In some cases the same buyer bough… -
Breaking down bundles into individual itemsHello Everyone, I am currently pulling in sales data from shopify. We have a core range of about 2…Answered Mattwjones 52 views 2 comments 0 points Most recent by DashboardDude Data Platform & Data Science -
How do I change the field type for a column on an existing table?My company recently released a new version of our online platform and I am mapping its new database… -
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 …Answered user026529 573 views 27 comments 0 points Most recent by MarkSnodgrass Data Platform & Data Science -
Convert DATETIME (UTC) to specific timezoneHello, Domosapiens! I have an interesting quandry. I have a data flow (using MagicETL - should I be…Answered ✓ imelendez 442 views 4 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science -
Improve Dataflow EfficiencyHello, Domosapiens, I currently have a data flow that is taking 14 min or greater to run. The desi…Answered imelendez 194 views 6 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science
-
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…Answered user084060 786 views 3 comments 0 points Most recent by jaeW_at_Onyx Data Platform & Data Science -
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…
