Daniel Stieglitz created NIFI-13922:
---------------------------------------
Summary: SplitExcel appears to drop column which has values from a
calulated formula
Key: NIFI-13922
URL: https://issues.apache.org/jira/browse/NIFI-13922
Project: Apache NiFi
Issue Type: Bug
Reporter: Daniel Stieglitz
Assignee: Daniel Stieglitz
When reading the SalesData.xlsx referred to in NIFI-13418 with a flow which
consists of
GetFile -> SplitExcel -> ConvertRecord where the ConvertRecord is configured
with an ExcelReader and a CsvrecordSetWriter it appears the values for column
'Sale_amt' which is a formula (column F * column G) is completely dropped as
seen in the sample below with column headers and the first row
{code:java}
OrderDate,Region,Manager,SalesMan,Item,Units,Unit_price,Sale_amt
43106,East,Martha,Alexander,Television,95,1198,
{code}
Although when reading one of the tabs with GetFile -> ConvertRecord the column
is not dropped e.g. of the column names and the first row
{code:java}
OrderDate,Region,Manager,SalesMan,Item,Units,Unit_price,Sale_amt
1515196800000,East,Martha,Alexander,Television,95,1198,113810.0
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
