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!!

[ShankerV]

Hi @LM_APAC2023 

Can you please share an example which will replicate your issue.

Many thanks

Shanker V

[Yoshiro_Fujimori · Accepted solution]

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.

[Qiu]

@LM_APAC2023 
We can not say too much without your sample data

but maybe a Dynamic Rename?