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 have the following setup:
i want to use the date from original file and search in the calendar table to find the corresponding Year, Qtr and Month Values.
for 1/15/2018 it should pick 2018 Q1 M1 . Similarly for 3/13/2017 it should pick 2017 Q2 M2 and then append to the original file for each record.
How can i achieve this.
Here is how you can go about creating a solution.1) convert all date times to actual date times using the datetime tool.2) on your calender output, use the 'generate rows' tool to create a row for each date between and including the start/end date.3) Join our new date field created using the generate rows tool against your main dataset.Solution attached.