How to convert data from a DT into a string format?

Help Studio
, ,
1

Hi everyone,

I want to convert a dt into a string format, the dt value is like:
[Column0
5 star
65%
4 star
17%
3 star
8%
2 star
3%
1 star
7%
]

Where I only got one column and one row, and I want to convert into this:

[5 - 65%]
[4 - 17%]
[3 - 8%]
[2 - 3%]
[1 - 7%]

How can I do that ??

2

Hi @marquezd

=>

A "Build Data Table" window displays a single-column table with star ratings and corresponding percentages for a product or service. (Captioned by AI)
A "Build Data Table" window displays a single-column table with star ratings and corresponding percentages for a product or service. (Captioned by AI)493×538 10.6 KB

Output → dt

=> Use the below LINQ expression:

finalString = String.Join(Environment.NewLine, dt.AsEnumerable().Where(Function(row, index) index Mod 2 = 0).Select(Function(row, index) "["+row(0).ToString().Split(" "c)(0) + " - "+ dt.Rows(index * 2+1)(0).ToString+"]").ToList())

The image shows a sequence of UiPath activities, including building a data table, assigning a formatted string to a variable, and displaying the string in a message box, which lists pairs of values from the data table. (Captioned by AI)
The image shows a sequence of UiPath activities, including building a data table, assigning a formatted string to a variable, and displaying the string in a message box, which lists pairs of values from the data table. (Captioned by AI)860×552 61.6 KB

Hope it helps!!

1 Like
3

It doesn’t work, because the only row contains all the information like this:

image

I put in an excel file beacuse UiPath does not allow me, but the information is all in row 0 in this case, any suggestions ??

4

Hi @marquezd

Is it throwing any error. As i have replicated the same data in Build Data Table as provided and the query works at my end.

Regards

5

Yes, it thows the error that there not value at position 1.

6

Hi @marquezd

Can you share the excel file you are using

Regards

7

example.xlsx (9.6 KB)
Sure, thats the excel File.

8

Hi @marquezd

Check the below workflow file
Sequence4.xaml (10.3 KB)

This image depicts an example of a UiPath workflow that reads data from an Excel workbook, processes the first row, joins it into a string, and displays a message box, demonstrating the operations step-by-step. (Captioned by AI)
This image depicts an example of a UiPath workflow that reads data from an Excel workbook, processes the first row, joins it into a string, and displays a message box, demonstrating the operations step-by-step. (Captioned by AI)960×687 24.2 KB

Hope it helps!!

9

Thanks a lot, it works but I hace to instaal some features to run

1 Like
10

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