We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks

Dynamic Input SQL Parameter Filter

coryfreeman3
5 - Atom

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 

3 REPLIES 3
cjaneczko
13 - Pulsar

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. 

coryfreeman3
5 - Atom

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?

apathetichell
20 - Arcturus

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-han...

Labels
Top Solution Authors