Pivot one column to rows from CSV file along with other fields

budati — Wed, 18 Sep 2019 22:47:11 GMT

Hi,

I have a CSV file where the last column has pipe-delimited text which needs to be split up on pipe and I have to pivot it into rows. The last column can have any number of values with pipe-delimited and it varies by each row. How can we accomplish this in NIFI?

Ex:

A, B, C|D

X, Y, X|Y|Z|B

The above file has to be converted to

A, B, C

A, B, D

X, Y, X

X, Y, Y

X, Y, Z

X, Y, B

Re: Pivot one column to rows from CSV file along with other fields

DennisJaheruddi — Mon, 23 Sep 2019 16:07:55 GMT

For this usecase the most natural solution is probably as follows:

1. Send message to a script for processing

2. Let the script turn your 1 row into an output of N rows

3. Optional: Split the rows in Nifi

question Re: Pivot one column to rows from CSV file along with other fields in Support Questions

Pivot one column to rows from CSV file along with other fields

Re: Pivot one column to rows from CSV file along with other fields