Filter not exist data from excel sheet

[Dhiaa-ABM (Art.Abm)]

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)

[Anil_G (Anil Gorthi)]

@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

[Dhiaa-ABM (Art.Abm)]

@Anil_G

fulldt.Clone()

THANK YOU, BUT NOT WORKING

[Anil_G (Anil Gorthi)]

@Anil_G

exists

@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

[Dhiaa-ABM (Art.Abm)]

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

[Anil_G (Anil Gorthi)]

@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

[Dhiaa-ABM (Art.Abm)]

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

[Anil_G (Anil Gorthi)]

@Dhiaa-ABM

sheet

@Dhiaa-ABM

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

cheers

[Dhiaa-ABM (Art.Abm)]

Yes I did

[Dhiaa-ABM (Art.Abm)]

[Dhiaa-ABM (Art.Abm)]

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

[Anil_G (Anil Gorthi)]

@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