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

Allow only columns from Data Input that is present in a separate list provided

Tej_Singh
8 - Asteroid

Hi Friends,

 

I have a problem to solve where in I need to allow only those columns from the Data Input that is provided as a list in a separate excel file. 

 

Data and Allowed Column files attached for reference.

 

Any thoughts how to solve this?

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Tej_Singh 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1646653085884.png

 

Hope this helps : )

 

Qiu
21 - Polaris
21 - Polaris

@atcodedog05 
if we really want to try something else 😁

@atcodedog05 
Learned how how to use Dynamic select. thanks.

0307-Tej_Singh.PNG

AkimasaKajitani
17 - Castor
17 - Castor

Hi @Tej_Singh ,

 

You can use this workflow. 

 

AkimasaKajitani_1-1646657289157.png

 

 

There is many approach to do it.

 

Tej_Singh
8 - Asteroid

Thank you @atcodedog05, for such a quick solution. Excellent solution! It worked without any issues. 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Tej_Singh 

Cheers and have a nice day!

Labels