How to do below scenario in datatable?

Help
1

I have attached my datatable here. As per my script, processing the “Publish status” as success in the specified column(Once the same “Product” completed).
I need to get the current “Publish status” in previous empty column for same “product”
which is based on the result success/ Failed.
Can anyone guide me how to do this?

Datatable

1 Like
2

So you mean like you need the empty value rows under publish status column
In that case
This expression would help once after fetching the datatable dt from read range activity
In a assign activity
dt = dt.Select( “ [Publish Status] = ‘’ “).CopyToDatatable()

Cheers @jamunatj

1 Like
3

Hi @jamunatj,

PFA this may help you to resolve that.
Just change the path of the excel file in the workflow.
Flowchart.xaml (14.8 KB)

Thanks & Regards,
@Spark_robot.

1 Like
4

Thanks Palaniyappan.

1 Like
5

Thanks @Spark_robot.

1 Like
6

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