Support Questions

Find answers, ask questions, and share your expertise

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
Super Guru

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