NiFi: Pivot: Columns to Rows

[#1]

Hello All,

How can I pivot record based data from columns to rows.

Here is an example of what I want to achieve:

Input:

A,B,C

M,N,O

Output:

A,B

A,C

M,N

M,O

Thanks!!

[#2 · Accepted solution]

Hi @M R

I don't believe there is an existing NiFi processor to transpose rows to columns. You would likely have to write your own script to do this, and invoke it via the NiFi processor ExecuteScript.

[#3]

Thanks Sonu