[
https://issues.apache.org/jira/browse/NIFI-12491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17866426#comment-17866426
]
ASF subversion and git services commented on NIFI-12491:
--------------------------------------------------------
Commit 21959560c59cfc7ce909d035fb4ed400e1111943 in nifi's branch
refs/heads/support/nifi-1.x from dan-s1
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=21959560c5 ]
NIFI-12491 Added Starting Row Schema Strategy to ExcelReader (#9081)
Signed-off-by: David Handermann <[email protected]>
> Add Use Starting Row Strategy to Excel Reader
> ---------------------------------------------
>
> 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
> Assignee: Daniel Stieglitz
> Priority: Major
> Fix For: 2.0.0-M5
>
> Attachments: image-2024-06-24-18-01-49-886.png,
> image-2024-06-24-18-02-36-592.png
>
> Time Spent: 5h 20m
> Remaining Estimate: 0h
>
> 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)
