PLEASE HELP - Data Manipulation doubt

Help Studio
1

In UiPath RPA

Below data is stored in Gereric varaible as InterfaceVariabe. Its extracted from table format data using screenscapping

[INTERFACE NAME INBOUND STATUS OUTBOUND STATUS TOTAL SENT TOTAL IN QUEUE STATUS TIMESTAMP
ATR Pre-Open Pre-Open 0 0 2025-01-15 02:41:40.030896
Autex Pre-Open Pre-Open 0 0 2025-01-15 02:41:40.056789]

My output should be in a data table “ExtractDataTable” with 6 columns as mentioned below . How to get the output?
INTERFACE NAME
INBOUND STATUS
OUTBOUND STATUS
TOTAL SENT
TOTAL IN QUEUE
STATUS TIMESTAMP

output should be like below :

The table displays the status of two interfaces, ATR and Autex, both in Pre-Open status for inbound and outbound with no items sent or in queue, along with their status timestamps on January 15, 2025. (Captioned by AI)
The table displays the status of two interfaces, ATR and Autex, both in Pre-Open status for inbound and outbound with no items sent or in queue, along with their status timestamps on January 15, 2025. (Captioned by AI)957×187 5.04 KB

Forum Engagement Daily Reports
2

@Venu_V,

You can use Generate Data Table activity for this

  • Input: Genericvariable.ToString
  • Output: DataTableVariable
  • Configuration: Set the appropriate row and column delimiters if required by the format of the data.
3

Delimiter not working . Its giving me only two columns if i select auto detect. Any other alternative solution Please?

4

@Venu_V,

Ok in that case string manipulation is the only option. Let me try this.

5

Can you please give me the code

6

can you please tell me the solution

7

@Venu_V,

Sorry, I will be looking into this whenever free not immediately.

8

Hi Venu,

Please check the below code.

data manupulation.zip (8.8 KB)

This image shows a spreadsheet with interface names, inbound and outbound statuses, total sent, total in queue, and status timestamps, all indicating zero activity and a date of January 15, 2025. (Captioned by AI)
This image shows a spreadsheet with interface names, inbound and outbound statuses, total sent, total in queue, and status timestamps, all indicating zero activity and a date of January 15, 2025. (Captioned by AI)877×153 4.21 KB

1 Like
9

Hi Venu,

If this is what you are looking for could please mark this as solution.

10

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