Summarize tool - Remove CountNonNull from variable name

LM_APAC2023

Hi all,

I have used the summarize tool to count the non null values for each of my variables. Following that I have new columns for each of my variables with each starting 'CountNonNull'+ variable name. 

Is there an easy way I can remove the 'CountNonNull' from my column names?

I have around 400 variable names each with different length so removing it manually would be a bit of pain..

Thank you!!

Yoshiro_Fujimori

Hi @LM_APAC2023 ,

I am not fully sure about your issue, but based on my assumptions, I have some proposals.

1. You can edit the Output Field Name on Summary Tool configuration

This is kind of a manual work, but you can change the field name to whatever name you like.

2. You can rename mutiple columns with Dynamic Rename

If you want to remove "CountNonNull_" by bulk, you can use Dynamic Rename tool.

Dynamic Rename tool configuration

I hope my answer is relevant to your issue.

DynamicRename.yxzp