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)
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
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?
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
Now working thanks you so much.
I added in ROW: Row.itemarray
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.