Comments
-
@arnabm Unfortunately, this is not currently an option in the UI. My recommendation would be to submit a post to the Ideas Exchange as Product Feedback for others in the community to upvote the idea of having an exported dataset containing the projections. If you haven't posted there before, check this post out…
-
This will run faster is you utilize indexing in MySQL (help article), which would require a transform for each of your tables to create two new columns for the month extracts you are joining on...e.g. LDGRDATE_Month and LDGRDATE_PriorMonth. Once those columns are created, you can add an index to them prior to joining them…
-
posted duplicate to new internal dojo board https://dojo.domo.com/internal/discussion/55255/how-can-i-use-the-match-function-with-a-declared-variable-string-in-a-mysql-dataflow#latest
-
The solution here requires using the SQL transform instead of the Table transform option in MySQL flows with a few steps below. Disclaimer: I would probably solve this in other ways, but to answer the specific question gives some detail on how stored procedures work in MySQL flows. Step 1: Write a SQL Transform to add a…
