Hello, i have a table input that gets data from a database and then transforms it into an xlsx file, it works well but i have a problem, there is a parameter on the query that sets the date that is going to be searching the data.
The parameter in question is the between 20240111 and 20240121, i wanted to use a variable instead of the number, like instead of 20240111 it would be diadehoje and instead of 20240121 it would be diadehoje+10. In this case the variable diadehoje would always take the current day and the diadehoje+10 would take 10 days after today, i already have these variables working and they return in the format that i need, i just can’t use them in the query. Is there a way to use them in the query? Thanks.
Hi! Vinicius
For the Table Input step please prepare the script in a previous step. Or alternately, use other steps like - Dynamic SQL Row, Execute SQL Script, Execute row SQL Script
1 Like
But when i use other steps the result of the query does not appear on the preview data of the process studio, this makes it impossible to generate the excel output.
1 Like
Hi! Vinicius,
Yes, you cannot see the results of the SQL steps it in the Process Studio Preview tab but you can immediately add an excel file after the SQL step and capture the results in the file.
1 Like
Hi Seema,
What specific excel output should I use in fetching the data that my Execute SQL Script had processed? I tried to add the column names manually in my Excel output but it couldn’t find the columns that my Execute SQL Script had processed
1 Like
Hi! Rommel,
You can use the Microsoft Excel Writer step.
1 Like
