I have a table with an ID, key and 2 columns with each contains pipe separated values. How can i parse column into multiple rows with the respective values?   Table that I have:   ID key itemno value 1 A 1|2|3 10|20|30 1 B 1|2|3 40|50|60 1 C 1|2|3 70|80|90   Expected output:   ID key itemno value 1 A 1 10 1 A 2 20 1 A 3 30 1 B 1 40 1 B 2 50 1 B 3 60 1 C 1 70 1 C 2 80 1 C 3 90   Really appreciate the help!   Thanks ... View more

Hello experts. I have a text file reading into Nifi flows. Part of my flow is splittext > extracttext. I have split the text as line by line using SplitText Processor. Daily file is generated with the process output reads as below:   20211129-04:00:26 RG1287.kla EOF mark not found! 20211129-04:00:55 RG9625.kla EOF mark found! ....and so on   How can i configure extracttext processor to result values as attributes for the each flow file. The values would be: date:20211129  Group 1:RG1287.kla Group 2:EOF mark not found!   Appreciate the help. Thanks!   ... View more