User2021

Oops! Thank you @MarkSnodgrass.

Although its not my strength my I will look into that. Thanks for always helping @GrantSmith Appreciate that!

Just thinking, is it doable in Mysql? Is there anyone who can help me in Mysql?

Yeah makes sense. So far whatever I see , there is no specific number of level it should go down. I have been asked to create a dataset starting with child and then parent>grandparent and so on till whenever it ends. Thanks @GrantSmith I may come back if I get stuck here.

Any ideas here?

Thanks @MarkSnodgrass . I should have been clear in my post. It has to be related too. child>parent>grand parent> great grand parent ...... It is bottom top so I need all parents in separate columns starting from a child ID. Any idea how to do it in ETL? I can join child and parent but I am confuse how many time I would…

@user062848 I solved my problem in ETL is that I used Domo calendar dataset and joined with dt col. It has to be left join so that you get all cal dates in the output. Now you have sales col and cal date col. You will use cal date col moving forward since it has all missing dates in it. Do the group by for sales and move…

This is what my dataflow looks like with adding calendar and filter for start and end dates Here each cal date is joining with all dates in the dataset. Lots of extra rows are added to output. Join between cal and data is left and cal is left table.

@MarkSnodgrass I am still stuck with this issue. I will try to explain again. I have a dataset with random dates column, ID column and Sales. I am trying to add all missing dates in the dataset. There are multiple sales on a single day , in that case I have grouped them to get one row for one date. Also, I have grouped the…

all dates between start and end date for each key. kind of subset

Exactly. I don't have constant but when I filter by key I am losing all cal table rows

I am doing outer join to bring all cal dates in. I do get it but then when I filter by key, I lose all extra(added) rows of dates.

No filters and it is joining on one date column. Which is the tbl.sales date = cal.dt

I need urgent solution for this issue. I tried to implement above solution of joining Domo Calendar but now I am losing all rows which are not matched with start and end date. Currently, I am getting all matched rows I want to get all missing weeks as well. The result dataset should be something like following table. All…

Thanks @MarkSnodgrass.

Got it! Thanks life saver @GrantSmith

Can anyone guide me how to solve daylight saving time problem in dataflow. I have already converted timezones as mentioned above by @GrantSmith

@GrantSmith Here it is same statement and mentioned that daylight saving will be adjusted.

I tagged you in another post where its same scenario

@GrantSmith It is not calculating daylight saving time.

Hey @GrantSmith this country/city combination is not working. Any other idea? CONVERT_TZ(`ColumnName`, 'UTC', 'America/Chicago') AS UTC_TO_CST

Thanks @GrantSmith you are always helpful!!

Left join then create a formula to get the difference?

The data is refreshed weekly and the purpose is to find the differences. I merge both datasets in one but then I am struggling to proceed the way to figure out difference in Col A Vs Col A of second table.