Filter not exist data from excel sheet

Hi all,
I need a help pls:
I have process read data from excel sheet and insert in Application, I am using Element Exist to move to true data and skip incorrect data, how can I move the incorrect data to other sheet or color it?
1-Read Range
2-Open Browser
3-For each row
4-Type Into
5-Element Exist
6-IF(than:Process continue with true exist----Else: Process skip false data and move to next data)

@Dhiaa-ABM

Welcome to the community

So inside the loop after your element exists…on the else side you can use add datarow and add the data to a different datatable…after read range add a assign to clonw the input datatable incorrectdt = fulldt.Clone()

After the loop write the data to excel as needed

Cheers

THANK YOU, BUT NOT WORKING

@Dhiaa-ABM

May I know what is not working… With this statement we cannot help you much. If you can share screenshots or xaml of what you tried and what failed would help in giving more details to resolve

cheers

I have problem with new data table and assign Value, do you have any example for it?

@Dhiaa-ABM

Say the output of read range is dt…

Create a new datatable variable newdt

Drag a assign

On left side give newdt and on right give dt.Clone()

Cheers

I did that but no output data to the new sheet, thanks

@Dhiaa-ABM

You added add data row as well and gave the new dt?

cheers

Yes I did

image

Now working thanks you so much.
I added in ROW: Row.itemarray

@Dhiaa-ABM

Please remove build datatable inside the loop

Have the clone outside loopand before for loop

Inside the add datarow add the currentrow in the datarow field

Cheers

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