[ https://issues.apache.org/jira/browse/NIFI-7810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ZhangCheng updated NIFI-7810: ----------------------------- Description: 'Translate Field Names' in PutDatabaseRecord and ConvertJSONToSQL can help us map the field and column by {code:java} private static String normalizeColumnName(final String colName, final boolean translateColumnNames) { return translateColumnNames ? colName.toUpperCase().replace("_", "") : colName; } {code} but this rule `colName.toUpperCase().replace("_", "")` is fixed. I think maybe we can define the rule using Expression Language. It's vary useful for 'Translate Field Names', but sometimes, there will be column names such as 'AB' and 'A_B' in the table, and `colName.toUpperCase().replace("_", "")` can not help was: 'Translate Field Names' in PutDatabaseRecord and ConvertJSONToSQL can help us map the field and column by {code:java} private static String normalizeColumnName(final String colName, final boolean translateColumnNames) { return translateColumnNames ? colName.toUpperCase().replace("_", "") : colName; } {code} but this rule `colName.toUpperCase().replace("_", "")` is fixed. I think maybe we can define the rule using Expression Language. > Improvement for 'Translate Field Names' > --------------------------------------- > > Key: NIFI-7810 > URL: https://issues.apache.org/jira/browse/NIFI-7810 > Project: Apache NiFi > Issue Type: Improvement > Components: Extensions > Reporter: ZhangCheng > Assignee: ZhangCheng > Priority: Major > Time Spent: 10m > Remaining Estimate: 0h > > 'Translate Field Names' in PutDatabaseRecord and ConvertJSONToSQL can help us > map the field and column by > {code:java} > private static String normalizeColumnName(final String colName, final boolean > translateColumnNames) { > return translateColumnNames ? colName.toUpperCase().replace("_", "") > : colName; > } > {code} > but this rule `colName.toUpperCase().replace("_", "")` is fixed. I think > maybe we can define the rule using Expression Language. > It's vary useful for 'Translate Field Names', but sometimes, there will be > column names such as 'AB' and 'A_B' in the table, and > `colName.toUpperCase().replace("_", "")` can not help -- This message was sent by Atlassian Jira (v8.3.4#803005)