Ignoring positive and negative value except for the specific folder name

Help Activities
, , , , , , , , , , , ,
1

Here is my input datatable

Folder Name. Amount

RFC. 925.31
Payment. -925.31

Insure. 925.31

Insure. 925.31

My output should be

Folder Name. Amount

RFC. 925.31

Insure. 925.31

Since the folder name has RFC should not take that remaining need to be removed as folder name payment and insurance has same value first is -ve and second one is +ve

2

Hello @sruthesanju

From the data what I understood is, you have a datatable and need to filter a few values based on some condition.

If yes, you can use the Filter datatable activity and frame the condtion for the columns.

Thanks

3

Hi @sruthesanju,
if you want to ignore folders with - Values you can make if condition (if folder name contains - ) then you will ignore all that value and if you want just to remove - you can use replace - value like below
Str.replace(“-”,“”)