Philipp Korniets created NIFI-12491:
---------------------------------------
Summary: ExcelReader - new Schema Access strategy: Use String
Fields From Header
Key: NIFI-12491
URL: https://issues.apache.org/jira/browse/NIFI-12491
Project: Apache NiFi
Issue Type: Improvement
Components: Core Framework
Reporter: Philipp Korniets
ExcelReader needs an ability similar to CSVReader to "Use String Fields From
Header" as a Schema Access Strategy.
Current implementation has:
1. Use Schema Name/Schema Text - this option relies on the order of the
columns. Possible issues - order of the columns change, but types dont. This
cause further calculations to be erroneous.
2. Infer Schema - replaces real column names with column_1,column_2 etc - this
again loses the "context" of the column and forces us to rely on how columns
are ordered.
Any workarounds make workflow more complicated.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)