-
Levels of Data in separate columns, bottom top approach
Hello, I am working on a request to provide all level of parent values for each individual child value. It is kind of bottom top approach. I have to start from a child ID column. For each child I need multiple cols of Parent ID. Something like below: The current data looks like I am trying to solve this in ETL. Any…
-
Adding Missing dates between start and end date for each category
Hello, I am trying to add missing dates from Start and End date for each category in Magic ETL. I tried to bring in Domo Calendar but confusion is what column from my dataset should I join with Cal.dt? Should that be start date or end date? Also, Then how would I create an output column which will have start date, missing…
-
Case Statement or Formula for creating a flag
I have to create a flag in a dataset where (IF columns A.a and B.a = A.b and B.b ) then I have to check cols A.c = B.c or A.d = B.d My Data is like Can someone help me in case statement. The one I have is not showing correct results. First two columns have to match to figure out discrepancies in next cols. If cols match it…
-
HTML Code shows with output values in filter or export of the card
Hello, I am trying to color cells in the card with HTML code. The issue is, if I filter or export the data for this card, all HTML code is showing up with the result. Is there any thing I need to add so that this code just works within beastmode? My code is CASE WHEN `column name` = 0 THEN concat('<div…
-
Converting Time zone with day light saving
Hello, I am trying to do a simple conversion of time zones of a datetime column from UTC to CST and EST. For some reason, I am getting error in this formula: CONVERT_TZ(`DateTimecolumn`, 'utc', 'cst') I also tried CDT instead of CST but getting error. I need something which works for time zone conversion as well as day…
-
Comparing two dataset outputs
I am trying to find a solution to compare output of two datasets. Both have same columns and same timeline but I want to create a flag if there is any difference in any of the col when we compare both outputs.
