Transformations
Discussion List
-
Showing some values based on SUM, other values based on the most recent date available for the week?I am working with a dataset that pulls in sales and inventory data for items on a daily basis. In …
-
Form Builder and Form Viewer TransformationI am trying to use submissions we get from forms in DOMO via form viewer/builder apps and turn them…
-
Lead Function in Rank and Window Returning Self Referencing ValueFor some reason I am getting a self referencing value rather than a NULL. In this example, I was e…
-
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…
-
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 …
-
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…Answered walker_page 101 views 5 comments 0 points Most recent by jaeW_at_Onyx APIs & Domo Developer
-
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…
-
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…