Hi, I was looking for an article on deleting unnecessary columns from my dataset. I found one that required ETL, so I created one based on that article. However, it's been stuck in "connecting" status for quite some time now. I've tried cancelling and re-running it, but it's been more than 30 minutes and my dataset still…
Is there a way if i have a dataset to simply create a unique id? For example, if I have a dataset of 10 rows and I want to label the row ID, and start at 1, then 2, etc.
Hello, could you help me with a calculation to create a new column in my table: If the "Fixed Value" column has a value, add "Fixed Contract" but if the "Spot" column has a value, put "Spot Contracts" in the newly created column.
Hi i have a question concerning structuring variable fields using group by. So currently I have 12 variable fields, where a user can input a budget amount in each field, for a total of 12 months. the budgeting can start during any given month, so i have a starting month field, that the user must use to enter the budget for…
We have various charts comparing the current month to the same month in the prior year and it would be nice to have a percentage over the chart indicating what the difference is between the two periods. I have searched several forums and played around in ETL and beast mode, but something that seems straightforward does not…
Hello DOMO - Good Day! I am using the Data governance dataset that has the users and groups. what we wanted to show is the pages/dashboard and then all the groups that can view it. currently, I can show the different pages and the different groups in different columns. just wanted to know if we can show all the different…
Hello, I am trying to accomplish a New DataSet using the Magic ETL where I combine multiple rows that have the same data in one column, but then create new columns for the data that isnt the same in other columns. To better explain, I have provided an example here. (Please see screenshot below) I have tried using "Group…
Hi all, using the following to calculate time differences between requested and actual drop off times: TIME_TO_SEC(TIMEDIFF(Actual Drop-off Time,Requested Drop-off Time)) / 60 Seems like the math isn't panning out (first column should be ~25 in the time difference column but instead is showing 1415.80). Haven't used the…
Hi, Can I use SubDate to filter a dataset within Magic ETL? We import our leadership team monthly. However, there are certain reports where I need the end of quarter leadership team instead of the most recent leadership team. Right now, I have the quarter end date hardcoded, but I would like to have a dynamic function.…
Hi everyone! We have set up an email connector and added the rules as below: HEADER ROW - 16 STARTING DATA ROW - 17 Update method - replace This is because the rows above 16 contain report summary data which are not required in the dataset. However, whenever the automated report comes through from the connector, we are…
It looks like you're new here. Sign in or register to get started.