Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to create attributes for every value in column in ni-fi?

avatar
Contributor

Hello!

 

So I am having dummy csv file:

 

year, value

2001,А

2001,B

2002,A

2021,B

2022,A

2022,B

 

Is there any way I can add attributes to this flowfile for every single value of 'year' column? I mean I need this flowfile to have year_2001 attribute with value 2001, year_2002 attribute with value 2002 and so on. I haven't found how to do it via ExtractText processor.

And the second question if it is possible to do so, how can I loop through all of these attributes in the future?

1 REPLY 1

avatar

Hi,

What are you trying to do with those attributes? It doesnt make sense that you need to create an attribute for each year value