Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

Alteryx Designer Desktop Discussions

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

Dynamic Input and Rename

aakanksha_garg
6 - Meteoroid

What exactly is dynamic input and rename tool? can someone explain with a example?

9 REPLIES 9
binuacs
21 - Polaris

@aakanksha_garg you can find the information in the designer itself

 

binuacs_0-1646390266922.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @aakanksha_garg 

 

Best way is to search for it and open examples like below.

 

atcodedog05_0-1646390396040.png

 

Hope this helps : )

 

TheOC
15 - Aurora
15 - Aurora

hey @aakanksha_garg 

as @binuacs has said, they actually have example documents within Alteryx itself. This will be your best bet for seeing them used practically (right click a tool -> open example).

Additionally, heres some documentation:
https://help.alteryx.com/20214/designer/dynamic-input-tool 
https://help.alteryx.com/designer-cloud/dynamic-rename-tool

Hope this helps,
TheOC


Bulien
atcodedog05
22 - Nova
22 - Nova

links weren't poping so posted another reply.

atcodedog05
22 - Nova
22 - Nova

Hi @aakanksha_garg 

 

To add

here is an interactive lesson on dynamic input tool : https://community.alteryx.com/t5/Interactive-Lessons/Connecting-to-Multiple-Sheets-at-Once/ta-p/8287...

Youtube video on dynamic input tool: https://www.youtube.com/watch?v=ELfKYatOJZM

 

Youtube video on dynamic rename: https://www.youtube.com/watch?v=D8COFBeRdeU

 

Hope this helps : )

Table of Contents Dynamic Input of Files: 1:00 Dynamic Input for SQL WHERE Clause: 8:16 Dynamic Input for SQL Stored Procedure Parameter: 14:09 A demo of three different way to use the Dynamic Input Tool: loading data from several files, replacing the WHERE clause of a SQL statement, and as input
Download a Free Trial of Alteryx! https://tinyurl.com/y5alktlu The Dynamic Rename tool renames columns within an input data stream. Use this tool to parse text files, to pull column names from the first row of data or a description file, or to rename a pattern in the column names, such as removing
aakanksha_garg
6 - Meteoroid

Thank You all!

 

TheOC
15 - Aurora
15 - Aurora

@aakanksha_garg 

Glad i could help! Let me know if you need any additional help 😁
Cheers,
TheOC


Bulien
atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @aakanksha_garg 

If our responses helps please don't forget to mark it as solution.

Cheers and have a nice day!

atcodedog05
22 - Nova
22 - Nova

Hi @aakanksha_garg 

 

And as @TheOC mentioned feel free to post more questions and ask for help Alteryx community members will be happy to help 🙂


Cheers and have a nice day!

Labels