[
https://issues.apache.org/jira/browse/NIFI-13304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17850113#comment-17850113
]
Philipp Korniets edited comment on NIFI-13304 at 5/28/24 5:11 PM:
------------------------------------------------------------------
Column with sheet name will do a trick, which will can be used in partition
record or QueryRecord
Example- sheet with data and sheet with dictionary which we want to join
(enrich):
we use ConvertExcelToCSV (which generates 2 flowfiles) then use joinEnrichment
of two sheet with the step of setting groupid and enrichment.role
was (Author: iiojj2):
Column with sheet name will do a trick, which will can be used in partition
record or QueryRecord
> ExcelReader - ability to split into flowfile per sheet
> ------------------------------------------------------
>
> Key: NIFI-13304
> URL: https://issues.apache.org/jira/browse/NIFI-13304
> Project: Apache NiFi
> Issue Type: New Feature
> Reporter: Philipp Korniets
> Priority: Major
>
> Currently ConvertExcelToCSV processor, if processing excel with multiple
> required sheets in it, produces flowfile per sheet.
> New ExcelReader produces one flowfile with all data in it
>
> There should be a way to configure output to be sheet-per-flowfile
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
