We have a small issue with excel sheet data loaded into DB table.
We are unable to load the data from excel in nifi if the field name have space or symbols.
ex: In excel field name is (Cost Center) , In DB (Cost Center) got error like column not matched.
if we send fileld name like Cost_Center then it is worked fine.
So, we request you that is there any possible in Nifi we can change (Cost Center (field name ) in excel to add(_) in that space to make it work?
ex:2 P&L item in excel field name also not work out because of & symbol.
Could you please suugest any approach for this if possible?