Concatenate values of Column Index1 and Column Index2 values and write in a single line, after following certain operations in Column Index2

[Neha_Kumari1 (Neha Kumari)]

Hello everyone ,

I am facing problem in concatenating values of my two column indexes. There is a fix header for column index1, but not fixed header for column2.
I need to sort column2, round off it, then concatenate the entire result in a single line.
Please find attached the workflow, I am getting the required mapping, but it overwrites the previous value every time, when I am trying to write in a single line.
Output needed in this format- +$3.8 M Price,+$1.4 M Other,+$0 M Acquisition,$-0.9 M Physical,$-6.5 M Mfg
Output getting -

Mapping.xaml (14.9 KB)

Thankyou in advance

[lrtetala (Lakshman Reddy)]

Hi @Neha_Kumari1

Is this the output you want

Sequence2.xaml (15.8 KB)

Cheers!!

[ppr (Peter Preuss)]

The general building Block

And enhanced (first Level)

(From d In DT.AsEnumerable
Let n = CDbl(d(1).ToString.Trim)
Order By n Descending
Let s = String.Format("${0} {1}", n.ToString("N2"), d(0).ToString)
Select v = s).ToArray

For flattening the Array we can use Strin.Join

For sure we can adapt more and fine tune

[ppr (Peter Preuss)]

@ppr

For sure we can adapt more and fine tune

E.G. with using

And

(From d In DT.AsEnumerable
Let n = CDbl(d(1).ToString.Trim)
Order By n Descending
Let s = String.Format("{0} {1}", n.ToString("$+#.#;$-#.#;(0)"), d(0).ToString)
Select v = s).ToArray

[Neha_Kumari1 (Neha Kumari)]

Hi @lrtetala ,

Thankyou so much for your response
Yes, I wanted the same way, just one thing I didn’t understand, for some values like +$-0.9, +$-6.5, it has both + and - signs there, even though we have this condition in our workflow ,
If ‘ItemValue.ToString.Contains(“-”)’ , just add $, otherwise add ‘+$’
while in output it shows the correct ones
Could you please help me understand this

[lrtetala (Lakshman Reddy)]

It’s my Bad @Neha_Kumari1

I forgot to add Append Items to Collections activity in else block…Please try below

Sequence2.xaml (17.2 KB)

Cheers!!

[Neha_Kumari1 (Neha Kumari)]

Hi @ppr ,

Thankyou so much for your response
I tried the solution you suggested. I also need to perform a few operations on all the values there, as dividing the value by 1000 then round it to one digit.
I was using this, ‘(Math.Round(ItemValue,1))/1000’ followed by ‘Math.Round(ItemValue,1)’ , so as it comes like +$3.8 M Price,+$1.4 M Other,+$0 M Acquisition,$-0.9 M Physical,$-6.5 M Mfg
how can we apply this to all our values in linq

[ppr (Peter Preuss)]

not complete clear the updated requirement

Are you looking for:

(From d In DT.AsEnumerable
Let n = CDbl(d(1).ToString.Trim)
Order By n Descending
Let nd = n / 1000
Let s = String.Format("{0} M {1}", nd.ToString("$+0.#;$-0.#;$0"), d(0).ToString)
Select v = s).ToArray

Also feel free to adapt:

EDITED: Fixed

And

[Neha_Kumari1 (Neha Kumari)]

Thankyou so much @lrtetala , for adding this to my knowledge
It works…

[lrtetala (Lakshman Reddy)]

Glad to be helped…If no more questions can you please close this topic…else happy to help @Neha_Kumari1

[Neha_Kumari1 (Neha Kumari)]

Yes, this was required, thanks for your clear explanation.
It works…Thanks a lot @ppr

[ppr (Peter Preuss)]

@Neha_Kumari1

It works

Perfect, just updated a few minor cosmetics.

So we do feel that the topic can be closed
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

[Neha_Kumari1 (Neha Kumari)]

Hi @lrtetala, thankyou for asking

I was trying the solution with one extra column, again dynamic header, it has ‘Item Comments’, which might be there or might not be. If comments are there, I need to add it along. It’s appearing correctly in logs. But I guess it’s not getting added to the Collection. Please suggest…
you could find image and xaml attached

Sequence2.xaml (23.0 KB)

[ppr (Peter Preuss)]

can you share some sample data with this optional Item Comments column
When a different output is expexcted also share the epected output sample. Thanks for support

[Neha_Kumari1 (Neha Kumari)]

Hi @ppr ,
$+3.8 M Price (+$0.86M spend delays) , $+1.4 M Other (Low margin) , 0 M Acquisition, $-0.9 M Physical, $-6.5 M Mfg. This is the solution I was expecting. I have kept the 3rd column values under braces, as required. I tried your solution, with slight modifications. It works…
LInqSol.xaml (10.3 KB)

Hey all
I tried both the solution, both works as expected. You could use @lrtetala one for conventional way and @ppr one for linq way. Thankyou so much both of you for your efforts, it helped a lot.