Column name with Special Character ($) and (#) causing Special Character Error Apache NiFi

[#1]

Hey, I'm receiving a special character error in Apache Nifi, I have 4 columns that could be causing it:

UCR_COST_IN_$,

ACTUAL_COST_IN_$

or

REQUESTED#,

ASSIGNED#

any help or solutions would be greatly appreciated!

[#2]

@James Fowler

In executesql processor change Normalize Table/Column Names property value to true

(or)

in your select query add an alias name to the special character field names without special character.

[#3]

so how would I do the 2nd one? I tried the first one but it put "Null" into all the rows in the destination table.

[#4]

@James Fowler

We need to use ReplaceText processor after GenerateTableFetch processor and replace select * with:

select col1, UCR_COST_IN_$ as UCR_COST_IN from table //replace * with column names and add an alias