Adding a Row Status to a Excel DB

Help Activities
, ,
1

Hi Team,

i have a DB that i read from excel… i have changed REFramework to read data from datarows to queue… now once every row has been read and executed i feel to update status in a “Status” column of DB, in Set Transaction status i want to add the status… how would i do that…

2

Hi @devasaiprasad_K ,
First you need to follow the steps as bellow:

  1. Add a data column called status. You can use Add Data Column Activity.
  2. Go to the SetTransactionStatus workflow and update the status column.
    image
    image866×997 30.3 KB

Cheers!

3

could you pls share the syntax for the same for adding a status into row data variable or anything similar to it.

4

Hi @devasaiprasad_K ,
Try the following steps as follow:

  1. Create a sequence called Update Status
    image
    image860×973 27.3 KB
  2. Into this sequence include the following activities:
    image
    image624×1040 26.2 KB

Hope it helps you!

5

thanks for the syntax

6

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