Magic ETL 2.0
Discussion List
-
再帰的ETLの更新について日毎に当日より先のスケジュールを更新するフローを考えています。（下記Excelのようなイメージ。前日まで… -
3Magic ETL can use Federated DatasetHi, We have number of cases where we want to use Magic ETL using federated Dataset. Can discuss the… -
Timestamp Runs Recursive Dataflow Magic 2.0Hello all! I feel like I have lost it but I am looking for a simple way to timestamp each run in a …Answered mbelmont 12 views 1 comment 0 points Most recent by GrantSmith Data Platform & Data Science -
Reg Ex difficultyI am attempting to pull out a string using Reg ex. I want to get the card name, so text after the …Answered renee12345 18 views 6 comments 0 points Most recent by GrantSmith Data Platform & Data Science -
Calculated Column if 2 Fields MatchHi - I am trying to create a calculated field similar to the = or EXACT function in excel - example… -
15Magic ETL - Undo ButtonCan we add an Undo Button to Magic ETL. This would be especially helpful when we accidentally dele… -
17Display Row count at every step in Magic ETLCurrently if you want to know your row count in Magic ETL at any stage other than the out put, you … -
How to correctly use distinct count and case when in etl (unknown error)Could someone help and explain what's causing this error? And how to correct it? Thank you -
1MagicETLタイル追加「ソート」MagicETLのタイルに「ソート」機能を追加いただきたいです。 ＜用途＞ 出力するデータを○○コード順、年月… -
Update Domo Magic ETLs via API/DomoCLIHowdy, experts, Is there a way to programmatically edit a Magic ETL? I am willing and able to use P… -
ETL formula vs Beastmode - result discrepancyGood afternoon, I've come across a headscratcher where a formula created within ETL is giving a dif… -
New Year Filtering Issues by Week / MonthMy date filters are on the struggle bus in the new year y'all. CASE when WEEK(`Week Date`) = Week(C…Answered RocketMichael 81 views 9 comments 0 points Most recent by RocketMichael Data Platform & Data Science -
How should can i remove Dot "." from a column?Hello, I have a column with multiple data and i need to remove the dot from all of it while keepin… -
Network Access from MagicETL?Am I correct in surmising that whatever environment runs Domo's MagicETLs restricts internet connec… -
How do I filter duplicative entries when two date fields are involved? (entry & modified dates)Hey Domo Smarties! [Annotated Screen Cap Below] What's the best way to filter out duplicate rows ac…Answered ✓ RocketMichael 21 views 2 comments 0 points Most recent by RocketMichael Data Platform & Data Science
-
MAGIC ETL FormulaHi Guys, I am working on a workflow, I have two datasets I combined using left join. Now I have a n… -
How can I convert an Excel date code into a normal M/D/Y formatted date?Hi All, I have some data that I link to DOMO via the Google Analytics connector. It's provided by …Answered ✓ HowDoIDomo 41 views 3 comments 0 points Most recent by DashboardDude Beastmode & Analytics -
Format Integer or Text String as DateHello, I am using HubSpot Connector to create contact reports in Domo. A custom HubSpot Date prope… -
Using RegEx to Extract DateHi all! I am looking for advice on extracting a Maturity Date from a column containing a string of … -
Magic ETL | Remove Duplicates Old RawHi, Assume my data like that I want to become If I use Remove Duplicates in ETL, it only keep the o… -
What are the est practices to maximize speed and minimize data storage when updating a large datasetWhat are the est practices to maximize speed and minimize data storage when updating a large datase… -
How can I format the date in a YOY chartHi all, Is there a way to format the date in a YOY chart? The tables in domo allow for you to custo… -
Removing Duplication and Ordering Objects within a Concatonated FieldHello, Our company offers several different product lines and I am attempting to count how many tim…Answered n____l____ 71 views 4 comments 0 points Most recent by n____l____ Data Platform & Data Science -
Holidays between two datesDataset A contains date_start and date_end. Dataset B is a calendar with a field called is_company_… -
Existing dataset as outputHi, I was editing my ETL and removed the output dataset part and had saved by accident. How do I ad… -
How to create a column which SUMS based on the grouping of another columnHello, I am trying to write an ETL which sums a value based on the grouping in another column (inv…Answered Mattwjones 35 views 1 comment 0 points Most recent by MarkSnodgrass Data Platform & Data Science -
Combine columns except when null (i.e., skip null)Hi there, Is there a way to combine values in multiple columns except when the value is null? For e…Answered ✓ tlammie1806 82 views 3 comments 0 points Most recent by ST_-Superman-_ Data Platform & Data Science -
Equivalent of IFERROR(VLOOKUP,IF(RIGHT(- in Magic ETLHi Guys, Hope all is good. I am using Magic ETL and trying to create a flow replicating the current…
-
Fixed Functions for Identifying the First and Last Connections for an EntityHi all. I built the following beast mode to identify the first and last connection for an entity. I…
