[ https://issues.apache.org/jira/browse/NIFI-12491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Handermann updated NIFI-12491: ------------------------------------ Fix Version/s: 2.0.0-M5 Resolution: Fixed Status: Resolved (was: Patch Available) > 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: 4h 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)