Dynamically Select columns by names

Question

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?

ChrisTX · Accepted Answer

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