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)

Reply via email to