Darshan Hiranandani : Need Help Incorporating Process Studio Variables into Table Input Query

Hi Team,

I’m working on a data transformation task where I use a Table Input step to retrieve data from a database and then export it to an XLSX file. Everything is functioning as expected, but I’m encountering an issue with using variables in the SQL query for date parameters.

Currently, the query includes a date range like this: BETWEEN 20240111 AND 20240121. I want to replace these hardcoded dates with variables:

  • diadehoje representing the current date (e.g., 20240111)
  • diadehoje+10 representing 10 days after the current date (e.g., 20240121)

The variables diadehoje and diadehoje+10 are working correctly and returning the right format. However, I’m struggling to incorporate these variables directly into the SQL query.

Does anyone have suggestions or solutions for how I can use these variables in my Table Input step’s query? Any tips on formatting or applying them correctly in the SQL statement would be greatly appreciated.

Thanks in advance for your help!

Best regards,
Darshan Hiranandani