A date type variable needs to have a functionality where the default value can be set to today's date
Hi all, I created a date-type variable and I wanted the default value of that variable to be currdate() or today's date. Is there a way to get this done?
My dataset has a date field that has 2022 running data on it. When I'm trying to create a line chart using that date range, it is repeating those weeks. I want to have only one instance of that week. How to resolve this? In the attached ss, you can see Week-6 getting repeated 3 times. I only want to see that week or any…
Hi all, I have a dataset with 100+ columns. There are many columns with null values. I would like to remove all those columns without manually selecting those columns using the Select Columns tile on Magic ETL. Is there a way to do this?
I am using a DOMO connector to import Salesforce data. The imported data has 30+ columns with no value. Can a query be written to remove all the columns with no values? I know I can write a script using Python/R but we don't have a scripting tile in our package.