You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Philipp Korniets (Jira)" <ji...@apache.org> on 2023/12/07 17:16:00 UTC
[jira] [Updated] (NIFI-12491) ExcelReader - new Schema Access strategy: Use String Fields From Header
[ https://issues.apache.org/jira/browse/NIFI-12491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Philipp Korniets updated NIFI-12491:
------------------------------------
Affects Version/s: 1.23.2
> 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
> Affects Versions: 1.23.2
> Reporter: Philipp Korniets
> Priority: Major
>
> 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)