How to filter datatable in reframework

Help Studio
,
1

Can anyone help me in filtering data table sequence in Reframework, I know how it works in normal process.

Share a sequence if possible.

Thanks

2

@Bhushan_Nagaonkar

May I know where you want filtwr?

Is it like you want to process only few by getting each item from transaction data

You can first only filter the table and use the filtered table …

Else in the process xaml check the column you want and just exit smoothly without doing anything using a flow decison or if condition

In_transactionitem.SpecificContent("ColumnName").ToString

Cheers

1 Like
3

I want to filter in PROCESS STATE what should be the condition in Input and output of filter data table.

I want to iterate a sequence
For example - Execute = “Yes” then it will exceute the flow or it wont

4

@Bhushan_Nagaonkar

can you be a little elaborate…when you want to filter in process state…do you want the transactions to be processed only when a condition is met? And is transaction item a datarow? And you want to ignore few in process?

If yes…then no filter datatable it would only be a if condition as you already would be getting each row

Cheers

5

I want to filter data table if the condition is met and then it should execute that process.

MicrosoftTeams-image (62)

In the above sheet, I want to add document path to upload document,
The conditions are you can upload the document once or multiple times depending on the situation.

Thanks

6

@Bhushan_Nagaonkar

Then first use a decision or if condition activity and check for the condition you have…

Then on the true side you would have filter datatable and this would be the data read from excel…and output also can be the same datatable as you anyways do not want to store whole table

Then depending on dt.Rowcount we can check if data is retrieved or not

Cheers

7

Thankyou for your solution will try and let you know.

1 Like