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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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