DataTable to string in uipath Moderan activities

Help Studio
, ,
1

Hi All,

previously we are using output data table to get the data table to string form.

but i want to know which modern activity can give data table to string

THANK YOU

2

Hi @vineelag

Output datatable is available in modern activities.

1 Like
3

Hi

Output datatable is already there in Modern activities as well
It’s under Installed activities
Check this out

IMG_8296
IMG_82961512Ă—2016 1.3 MB

Cheers @vineelag

1 Like
4

image

how to give source range, if the source range is dynamic

@Palaniyappan

5

Hi @supriya117

you can achieve this using the “Output Data Table” activity in combination with some modern features of UiPath. Here’s how you can do it:

  1. Use the “Read Range” activity to read your DataTable from a data source into a UiPath DataTable variable (e.g., dtInput).

  2. Use the “Output Data Table” activity to convert the DataTable to a string. This activity allows you to specify the DataTable you want to convert (dtInput), and it will output the DataTable as a string in the desired format.

  3. Optionally, you can assign the output of the “Output Data Table” activity to a string variable (e.g., dataTableAsString).

Here’s a summary of the steps:

- Read Range: Read your DataTable from a data source into a UiPath DataTable variable (e.g., dtInput).

- Output Data Table: Use the "Output Data Table" activity to convert dtInput to a string.

- Assign: If necessary, assign the output of the "Output Data Table" activity to a string variable (e.g., dataTableAsString).

- Use the 'dataTableAsString' variable in your workflow as needed.

Thanks!!

6

You can create a variable to hold the range and can be built with text or string you want
Then pass that variable to that Source range property

To enter a range, table, or sheet manually, select Custom Input.

Alternatively, you can select Open in Advanced Editor and enter a VB expression.

Cheers @vineelag

7

Hi @vineelag

Use Output DataTable activity which will convert your data table variable into string variable.

Hope it helps!!

1 Like
8

@vineelag

You can give the first cell and all the range would be considered

Cheers

1 Like
9

@Palaniyappan

I am not able to see any DT stored property for storing the output DT,

where can i see the filter output Data

image
image1130Ă—615 29.4 KB

Thank You!!!