Alteryx Designer Desktop Discussions

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

Dynamic Input for multiple ranges Excel

anhnguyenngoc2002
7 - Meteor

Hi everyone,

 

I need to input multiple ranges in a same excel file, each range used for a different purposes

I use input tool to import every range I want to process, however if I have many ranges I have to use a lot of input tools. Instead, I want to use dynamic input tool & text input (where I will enter ranges). After that I can use each range for each calculation. How can I do this? Thank you so much!

I have attached my sample data and a sample workflow for my idea. If you have any better ideas please help me.

 

 

 

 

 

 

2 REPLIES 2
flying008
15 - Aurora

Hi, @anhnguyenngoc2002 

 

Another way fyi.

flying008_0-1686021570956.png

 

Input     Output     
F1F2F3F4F5 Reporting MonthJan-23Feb-23Mar-23Apr-23Range
Sales     Company A1366294429652343Sales
Reporting MonthJan-23Feb-23Mar-23Apr-23 Company B1488192123722248Sales
Company A1366294429652343 Company C2845212725612679Sales
Company B1488192123722248 Company D1918252121831826Sales
Company C2845212725612679 Company A0.59660.57810.58230.5668Completion
Company D1918252121831826 Company B0.53120.44270.4590.5311Completion
      Company C0.47860.44330.47660.559Completion
Completion     Company D0.59130.55110.92690.8394Completion
Reporting MonthJan-23Feb-23Mar-23Apr-23 Company A99878297Rewards
Company A0.59660.57810.58230.5668 Company B79888370Rewards
Company B0.53120.44270.4590.5311 Company C97889978Rewards
Company C0.47860.44330.47660.559 Company D98899087Rewards
Company D0.59130.55110.92690.8394       
            
Rewards           
Reporting MonthJan-23Feb-23Mar-23Apr-23       
Company A99878297       
Company B79888370       
Company C97889978       
Company D98899087       

 

nagakavyasri
12 - Quasar

Correct the format of Range in text Input tool and can use Interface tools to select the range:

 

Screenshot 2023-06-06 144025.png

 

 

Labels
Top Solution Authors