in my excel i have two rows but my transaction data it is taking only 2 row i had set the transaction numbet to 1 and out_transactionitem=io_transactiondata.rows(in_transactionnumber-1)
Do you have header row in the excel?
or only 2 rows, both are data rows?
If you do not have header rows then while reading the data from that excel disable the Add Headers option in the read range activity.
I have header row and with two rows in excel sheet@sarath
I want to clarify whether we need to loop through the rows what we have to do with transaction number
i had intialized it to 1 means it starts with first row leaving the header file
I hope you are using RE Framework, by default the TransactionNumber is 1 only.
No need to loop through the rows, the framework will take care of that part.
The TransactionNumber value will be increased in the SetTransactionStatus.xaml, check there which value is coming first time when you are starting the process.
SetTransactionStatus.xaml (46.6 KB)
this is my set transaction status workflow my transaction starting from 2 but i want to start from first row
@sarathi125
Your SetTransactionStatus.xaml looks good. But my double is from Main.xaml what is the TransactionNumber passed to the GetTransactionData.xaml and check the transaction assignment there as shown in the image.
GetTransactionData.xaml (9.3 KB)
the transaction number is 1 i had passed to transaction data @sarathi125
Debug the process, keep a breakpoint inside the GetTransactionData.xaml for the first time what value you are getting for the in_TransactionNumber
actually i had given in the import arguments of get transaction data as in transaction number=transaction number now i had changed to thein_transactionnumber=1 now i am getting from first row but same row it is taking for the another transaction also it is not taking the second row
@sarathi125
Can you please download the ReFramework for Tabular Data from the below link and compare with your xamls.
No need to define or increment the transaction number from our end. In Framework in the Main.xaml it is initialized with 1 and in the SetTransactionStatus.xaml it will be increased or retained based on the transaction status.
https://go.uipath.com/component/reframework-for-tabular-data
i had seen the attachment @sarathi125 thanks for that my workflow is running good but only my first row is looping it is not taking my second row for all process transactions it is taking my first row data
@Manisha541,
Where you have given this
if i give in_transactionNumber value as 1 it is taking my second row only
sorry if i give value as 1 it is taking my first row looping continuosly
if i give transaction number as value then it is taking my second row only once
You should not hard code that value there in the arguments, then every time it refers to 1, hence it is processing the first row continuously.
Try to change that like the following and try again,
Ok i had changed and kept the screenshot of output it is taking only the second row of excel
@sarathi125
Main.xaml (52.1 KB) GetTransactionData.xaml (9.3 KB) SetTransactionStatus.xaml (46.6 KB) InitAllApplications.xaml (13.5 KB)
can anyone check my workflow
error:i have two rows in excel including header it is taking only second row ,it is not taking the first row
plz help me out in thisConfig.xlsx (20.4 KB)
Anil_G
Shakib
ashokkarale
sharu_priya
sven.wullum1
Babjee.Vangipurapu
Prathamesh_Trimurti_Hulav
riley
sharazkm32
A_Learner