Add values columns with a similar name

Node Development
1

Hi! I 'd like to know how can I add values from 2 or 3 columns with a similar name. I have to run through all columns and match the columns with a similar name, e.g.:
AAA_1 AAA_2 ->AAA
0 1 1
1 0 1
0 0 0
1 0 1
1 0 1
Thank you so much!!

2

Hi Savacano
is this always the same pattern? hence something underscore and a number?

Than you could unpivot all of them in one column. Use the cell Splitter configured with a underscore and finally group on the split value and sume them up.

Let me know if you need an example flow.
Cheers, Iris

3

HI! thank you so much four your answer. The pattern is the same always, I have :
url ref1_1 ref2_1 ref3_1 … ref1_2 ref1_3
uri1 1 … 0 0
uri2 0 … 1 0
uri3 0 … 0 1

and I need :
url ref1 ref2 ref3
uri1 1 0
uri2 1 …
uri3 1 …

I 'd appreciate so much an example.
Thank you :slight_smile:

4

Hi! Thank you so much, It works!! :slight_smile: ! ^^

5

Now, I have :

Uri ref sum
uri1 ref1 1

How can I get :

Uri ref1
uri1 sum(ref1)

Thank you so much!!

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.