Split Nifi Attribute Value To Multiple Attributes

Question

I have a file which i get using the GetFile Processor.

The flowfile generated from this has an attribute (filename).

I want to split this "filename" attribute with value "ABC_gh_1245_ty.csv" by "_" into multiple attributes

ATTR1 = "ABC"
ATTR2 = "gh"
ATTR3 = "1245"
ATTR4 = "ty.csv"

I presume that there are no processors available for this functionality in nifi 1.7.1

I googled and found this custom processor: https://github.com/guvencenanguvenal/nifi-splitcreateattribute

It still doesnt work. It errors out with 'Attribuite dont found'

Sivaprasanna Sethuraman · Accepted Answer · 2019-01-04 09:06:26Z

4

To solve this, you can leverage ExecuteScript or ExecuteGroovyScript processor. The following scrip would do the job just fine. It is written in Groovy though.

flowFile = session.get()

if (!flowFile)
    return

filename = flowFile.getAttribute('filename')
splits = filename.split('_')
attrsMap = [:]

splits.eachWithIndex {
    split, index -> attrsMap.put("ATTR" + index, split)
}

attrsMap.each{ k, v -> println "${k}:${v}" }
flowFile = session.putAllAttributes(flowFile, attrsMap)
session.transfer(flowFile, REL_SUCCESS)

Screenshots

edited Jan 4, 2019 at 9:06

answered Jan 4, 2019 at 9:01

Sivaprasanna Sethuraman

4,1525 gold badges36 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

blackfury · Accepted Answer · 2019-01-04 08:52:51Z

1

The below processor works perfectly fine...

https://github.com/guvencenanguvenal/nifi-splitcreateattribute

Below is the config needed:

Split Attributes Name: ATTR1, ATTR2, ATTR3, ATTR4 Attribute Name Which Split: filename\ Split Separator (Regex): _

answered Jan 4, 2019 at 8:52

blackfury

6853 gold badges12 silver badges22 bronze badges

Collectives™ on Stack Overflow

Split Nifi Attribute Value To Multiple Attributes

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related