I have to update in excel after completion of my transaction item in required row

[shaik.muktharvalli1 (shaik muktharvalli)]

Hi UiPath Team,

I have to update in excel after completion of my transaction item in required row

Input data:

I have populated only status is blank, after completion each transaction I have to update in required CR_Number row like Closed.

Output:

Note: I have to update every transaction item

Thanks
Shaik

[Melroy_Dsa]

Hi @shaik.muktharvalli1 ,

Based on what I’ve understood you can just have a simple If activity with the following condition,
If String.IsNullOrEmpty(in_TransactionItem.SpecificContent(“Status”).ToString)
Then Assign “Closed” in_TransactionItem.SpecificContent(“Status”)

Hope this helps!

[ashokkarale]

Hi @shaik.muktharvalli1 ,

I would suggest not to take only blank by filtering. Instead use one if condition in letter stage to decide if need to process the row or not.

If the Status is blank, process the row and change the status to Closed.

Else,

Do nothing as status is already something.

[shaik.muktharvalli1 (shaik muktharvalli)]

Getting this error

anyone help please

Thanks
Shaik

[Akash_Javalekar1 (Akash Javalekar)]

May i know why you are passing hardcoded values?

try this linq query

Read_Data.AsEnumerable().Select(Function(row)
If row(“Status”).ToString = “” Then row(“Status”) = “Closed”
row
End Function).CopyToDataTable()

[shaik.muktharvalli1 (shaik muktharvalli)]

@Akash_Javalekar1

Closed

I have to update status column from each Transaction item
some time it will update closed, some time it will exception details i have to update in their status.

thanks
shaik

[lakshmi.mp]

Hi @shaik.muktharvalli1 ,
Have a look on this workflow and excel file output stored in Sheet2.
Sequence1.xaml (10.0 KB)
status.xlsx (9.7 KB)

[shaik.muktharvalli1 (shaik muktharvalli)]

But I have to update as per transaction item

I have to update one by one as per transaction item

thanks
shaik

[Akash_Javalekar1 (Akash Javalekar)]

Are you using reframeworko or normal sequence?

[shaik.muktharvalli1 (shaik muktharvalli)]

I am using REFramwork

thanks
shaik

[Akash_Javalekar1 (Akash Javalekar)]

Then in set transaction status you can directly update the status as per transaction status

[shaik.muktharvalli1 (shaik muktharvalli)]

Can you share sample workflow to understand

[Akash_Javalekar1 (Akash Javalekar)]

Hi @shaik.muktharvalli1

Please find below screenshot if your transaction item successfull you can add in success sequence in set transaction status likewise if any bussiness exception you can update the status column