Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Dynamically Select columns by names

dlesny
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?

2 REPLIES 2
ChrisTX
15 - Aurora

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

 

Capture.PNG

 

 

dlesny
8 - Asteroid

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

Labels