Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Dynamically Select columns by names

8 - 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
12 - Quasar

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

 

Capture.PNG

 

 

Highlighted
8 - Asteroid

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

Labels