[
https://issues.apache.org/jira/browse/NIFI-13922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel Stieglitz updated NIFI-13922:
------------------------------------
Description:
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 a flow which consists of 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}
was:
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}
> 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
> Priority: Major
>
> 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 a flow which consists of 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)
