community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Dynamically Select columns by names

Asteroid

Hello.

I am pulling Task Information from CA Agile (Rally) by UserStory.

Depending on how many Tasks is under the User Story the amount of columns changes so I would like to dynamically select columns by names with wildcards.

ex:

QueryResult_Results_0_FormattedID

QueryResult_Results_0_Iteration__refObjectName

QueryResult_Results_0_Name

QueryResult_Results_0_Owner__refObjectName

QueryResult_Results_0_Release__refObjectName

QueryResult_Results_0_State

QueryResult_Results_0_WorkProduct__refObjectName

QueryResult_Results_0__refObjectName

QueryResult_Results_1_FormattedID

QueryResult_Results_1_Iteration__refObjectName

QueryResult_Results_1_Name

QueryResult_Results_1_Owner__refObjectName

QueryResult_Results_1_Release__refObjectName

QueryResult_Results_1_State

QueryResult_Results_1_WorkProduct__refObjectName

QueryResult_Results_1__refObjectName

QueryResult_Results_2_FormattedID

 

But I Only need:

 

QueryResult_Results_0_FormattedID, QueryResult_Results_1_FormattedID, QueryResult_Results_2_FormattedID

 

Depending on number of Tasks the number betwen _0_ , _1_ will vary. How to make sure I am always getting all of them dynamically?

Highlighted
Bolide

Do you only want the columns with FormattedID in the name?  Try this

 

Capture.PNG

 

 

Asteroid

Awesome, Thank you. I need more columns but once I know the way I can Amend and Apply :) Thank you again

Labels