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 taken start date in StartDate text input with 2019-08-01, FinalDate as DateTimeToday() and a loop StartDate <= FinalDate, EndDate as DateTimeAdd(StartDate,6,'days').
I am able to get data filtered on the basis of StartDate and EndDate.
The problem is I want the output file to be FileName_StartDate_EndDate.csv. How can I reusue StartDate and EndDate values to append in the file. I tried using formula tool but I dont know how to call StartDate and EndDate in it so that I can use it in outputfile name
have you tried this option below in the Output tool? You can construct your file name using the formula tool, appended to the data set that you want to output and use this option below to generate the file name dynamically.
This also allows you to generate multiple files with different names using the values from a Field.
Yes, I am using the output tool as you have suggested. The issue is that the start date and end date are not the fields in my query. I have data for each day and I have where clause based on start date = 2019-08-01 and end date as start date +6 as shown in the below image.
I have also used formula tool to add AppendFile to be used in the file. I need the file name as 'FileName_StartDate_EndDate.csv' but I am not able to get values of start date or end date after the dynamic input.