You can translate the question and the replies:

remove all _0 from field names on new base view

we have config turned on where if a field is renamed because of space or special characters it appends underscore 0 to the end of the field name, we want to keep that feature on but I have a view of like 100 fields and half of them have it. Is there an easy way using the VQL shell to replace all of the underscore 0 references at once?
07-10-2021 14:23:59 -0400

2 Answers

Hi, With this scenario, I often use the **ALTER TABLE** command from the VQL shell. More details are found in the *alter column* clause in the [Modifying a Base View]( guide. Hope this helps!
Denodo Team
17-10-2021 22:51:00 -0400
What config adds these 0s to the end of column names?
12-01-2023 14:32:08 -0500
You must sign in to add an answer. If you do not have an account, you can register here