Uipath re framework convert to datatable

Help Studio Web
, ,
1

I am converting default UiPath default re framework structure to datatable Approach, I have done converting all those basic steps.

I Needs to run the process data table approach only once: I am doing the get Transaction Data xaml inside using if condition to check the in_TransactionNumber =1

Else part I am mentioned out_TransactionItek = Nothing
In then part if I am not having data table means what condition I Needs to write out_TransactionItem = “”.
Anyone help for the solution

2

Hi @BHUVAN

in the then part of get transaction data, if your datatable dt_input is empty or has no more rows, you can set out_transactionitem = nothing to stop the process.
Use condition like in_transactionnumber less than or equal to dt_input.rows.count in the if activity. if false, set out_transactionitem = nothing. if true, set out_transactionitem = dt_input.rows(in_transactionnumber minus 1).

3

@BHUVAN,

What’s the datatype of the out_TransactionItem ?

4

Hey @ bhuvan hope you change the Transaction item type from queue to Datarow .
this is important if you are working with Excel not Queues.after updating those things you have to change some certain things in the Get Transaction xaml.i share the screenshot which help you .

This flowchart visually outlines the process of retrieving, assigning, and saving information for a new transaction item, emphasizing conditional checks and logging for transactions like invoices. (Captioned by AI)
This flowchart visually outlines the process of retrieving, assigning, and saving information for a new transaction item, emphasizing conditional checks and logging for transactions like invoices. (Captioned by AI)591×527 16 KB

The image shows a section of a workflow design interface where transaction information is being assigned to various log fields using multiple "Assign" activities. (Captioned by AI)
The image shows a section of a workflow design interface where transaction information is being assigned to various log fields using multiple "Assign" activities. (Captioned by AI)551×578 27.7 KB

The image shows a workflow diagram with conditional logic to assign transaction data using "If" and "Else" statements, setting values for transaction fields and IDs. (Captioned by AI)
The image shows a workflow diagram with conditional logic to assign transaction data using "If" and "Else" statements, setting values for transaction fields and IDs. (Captioned by AI)722×631 29.9 KB

change these steps now you are good to go with Excel

cheers

1 Like
5

Hello @BHUVAN,

You can refer this video.

1. UiPath RPA Use Case : Create Card | ReFramework without Orchestrator Queue | With Excel Datatable

Regards,
Bharat

6

@BHUVAN

in condition use in_TransactionNumber =1 AndAlso dt.Rowcount>0

cheers

7

Hi @BHUVAN

You can refer below post on same.

It has all notes about changes that needed to be done for datatable approach. Also includes the sample project for same.

Hope this helps.

Regards
Sonali

8

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