Live Training
Join our live sessions led by expert instructors to level-up your analytic prowess and Alteryx product knowledge.In-Database Processing
Working with large database instances? Why waste time moving data to and from the database server? See how to utilize the In-Database tools to blend and analyze the data directly within the database environment to realize significant performance improvements.
At the time of the event, please join the session HERE.
Recordings will be posted 1-2 business days following the event.
Please refer to the attachments of this event in the bottom right corner to download a calendar invite.
This event is a part of a larger six part series series. You will find this session useful if you are looking simply to learn more on the topic covered. If you want to participate in future sessions, look out for the following events:
- Intro to REST APIs
- Iterative Macros
- Building Chained Applications
- Python Integration with Designer
- In-Database Processing
- Parsing with Regular Expressions
Session Playback
Hi @Terry_M
Please see below.
I used Dynamic in-DB here. Text file has two fields as connection and query. Connection is the field name of you already defined in your manage in-DB connections. Query is the query you like to run. I designed here as an application, so it it will ask you to enter connection name and query. After runs, it will show you the records. When you share this workflow, assuming your users have own connection info already is defined. The beauty of this method you are independent to write any query. Please let me know if this is you want to achieve.
Albert
