Column Grouping values

[JDong]

Hi All,

I have a column which is a formula field and combination of a string and float field.

The grouping based on Sl No does not work since the end field is a V_WString field.

Sl No	Column
1	10 - 50 K
2	0
3	25042.08
3	33000
4	10 - 50 K
4	10 - 50 K
4	10 - 50 K
5	[Null]
6	10 - 50 K
7	[Null]
8	No

Above is the table and please guide how to group based on the SlNo since it does not work.

Expected

Sl No	Column
1	10 - 50 K
2	0
3	58042
4	10 - 50 K
5	[Null]
6	10 - 50 K
7	[Null]
8	No

Thanks

[JDong]

Hi @Ladarthure 

Thanks a lot this works like a charm !

One additional question I had was in case this solution is to be joined in a larger flow and I need to summarize the 2nd column again...how can I achieve since the end output is in String field.

Say I add additional columns which kind of split the rows due to the values...how will I summarize the field again ?

Thanks

[Ladarthure]

You could do this process again or process more your data for the text part, it depends on what your data looks like and what you want to do, hard to answer without the whole context 🙂