[NIFI-12491] ExcelReader - new Schema Access strategy: Use String Fields From Header

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.23.2
• Component/s: Core Framework
• Assignee: Unassigned
• Reporter: Philipp Korniets
• Created: 07/Dec/23 17:14
• Updated: 07/Mar/24 12:59

Description

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.

 

 

 

Issue Links

• is a child of: NIFI-11167 Add Excel Record Reader