Add values columns with a similar name

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.:
0 1 1
1 0 1
0 0 0
1 0 1
1 0 1
Thank you so much!!

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

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:

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

Now, I have :

Uri ref sum
uri1 ref1 1

How can I get :

Uri ref1
uri1 sum(ref1)

Thank you so much!!

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