This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to leverage the "Generate Rows" tool to add (missing) dates to my data set. The goal is to have a row for every single day that falls within the min/max date range of a given project ID. The visual will make it easier-
Desired Data Output (the grey rows are the rows I would like to have added):
The generate rows tool in your case would need to know the minimum and maximum date for each product ID. After that, join back to your original dataset and use the multi-row formula tool to fill in the gaps.