question Re: NiFi: Pivot: Columns to Rows in Archives of Support Questions (Read Only)

NiFi: Pivot: Columns to Rows

mayank_rathi — Thu, 10 Aug 2017 23:41:04 GMT

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!!

Re: NiFi: Pivot: Columns to Rows

ssahi — Fri, 11 Aug 2017 00:18:11 GMT

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.

Re: NiFi: Pivot: Columns to Rows

mayank_rathi — Fri, 11 Aug 2017 05:42:44 GMT

Thanks Sonu