Support Questions

Find answers, ask questions, and share your expertise

NiFi: Pivot: Columns to Rows

Contributor

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

1 ACCEPTED SOLUTION

Guru

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.

View solution in original post

2 REPLIES 2

Guru

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.

Contributor

Thanks Sonu