Removing "Count" in Name After Cross Tab Before Table in Multiple Fields

[JacobGFMR]

Hello,

I am needing help removing "Count_" from the Column Name from multiple columns. 

I have used the cross tab element to determine the count, but I am now needing to remove the "Count_" from the column names. 

I know I can use the Text To Columns element to achieve this, but it only works for 1 column name at a time, and I have close to 15 and new ones could exist after data is obtained in the work flow. 

This is how the data looks..

Item	Sub	Count_Joe	Count_Bob	Count_Mary
AAAAA	BBBBB	1	4	7
CCCCC	DDDDD	2	5	8
EEEEE	FFFFF	3	6	9

This is how I need to have it look.

Item	Sub	Joe	Bob	Mary
AAAAA	BBBBB	1	4	7
CCCCC	DDDDD	2	5	8
EEEEE	FFFFF	3	6	9

Thank you. 

[BA02 · Accepted solution]

You can use the dynamic rename tool. Try joining the datasource to the "L" input and select "Remove Prefix/Suffix" as the Rename Mode. You can do this to multiple fields at once. Hope it helps!