How to get row number for a specific column?

image

Hello, I hope you all are doing good.
As I am a beginner, and I have question regarding Ui Automation.

I want to scrap the UserIDs column and check if there is multiple row value presents in that column,
Can someone tell me what will be the expression/Logic for the same?

Many Thanks :slight_smile:

Hi

Welcome to UiPath forum

Say you have this tabular format in a application
Then use DATA SCRAPPING and get the output as a datatable named dt

  1. Now use a FOR EACH ROW activity and pass dt as input

  2. Inside the loop use a IF condition like this

Split(CurrentRow(“UserId”).ToString, Environment.NewLine).Count > 0

If true it goes to then block which means it has more than one row of value in each cell

Cheers @Shubh_k

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