Dynamic Input SQL Parameter Filter

Question

Hi all,

I am using a dynamic input tool to pull data out of SAP HANA but unfortunately the data is pulling 88.1M records which causes the workflow to take forever to run. I have a DF_DATE field that is being pulled in from the database as a Date. Is there a way to edit the SQL editor to pull in just records starting in 2023-01 and forward? This should help reduce the amount of records that I am pulling in. I am using a batch macro to pull in specific organizations but once it hits the dynamic input tool it takes over a day to run the workflow.

Thanks!

Cory

apathetichell · Answer

This be Alteryx. We help with Alteryx problems. You can ask use questions --- we try to help. we volunteers. You are asking a question about how to use SAP S4 HANA SQL Maybe go here? https://community.sap.com/t5/technology-q-a/filter-the-data-from-current-date-to-column-date-sap-hana/qaq-p/12375217

coryfreeman3 · Answer

Thank you for your response. Yes I am aware of where the SQL is located, more so looking for the syntax. The field is a Date field so would I include the filter in the where clause for example like where (database name) year(DF_DATE) > 2022?

cjaneczko · Answer

Yes, edit the query in the configuration of the Dynamic Input tool. Click on the tool and then click on the Edit button in the Input Data Source Template section of the configuration window. The SQL for the query is on Line 11 of the configuration window.