How to validate two values from excel withOut for each

Byrpazone Reading Time: 3 minutes

If you want to validate two values from Excel without using a For Each loop,

you can use the following approach in UiPath:

step-1: read range activity:

Use the Read Range activity to read the range of cells that contain the values you want to validate from the Excel worksheet. Store the output in two separate DataTable variables.

step-2: use the lookup data table:

First data table variable:

Use the Lookup Data Table activity to check if the values exist in the Data Tables. Configure the properties o the Lookup Data Table activity as follows:

  1. LookupValue: This property represents the value you want to find in the data table. It can be a specific value, a variable, or an expression that evaluates the value you are searching for.
  2. ColumnName: This property indicates the name of the column in the data table that you want to search in. It specifies the specific column where you expect to find the lookup value.
  3. Result: This property stores the result of the lookup operation. It can be a variable or an output argument that will hold the output value after the lookup is performed.

step-3: again taking the lookup data table:

second data table variable :

Repeat step 2 for the second value you want to validate, using the second DataTable variable.

store the second result value in another variable

compare the variables or validate the variables:

Compare the OutputValue variables to determine if the values exist in the respective data tables.

By using the if the activity to validate the two variables

if the two results variable is equal show the message box as “two variables are equal” Otherwise show the message box ” two variables are not equal”

this activity is used to compare or validate the two variables

To validate two variables in UiPath, you can use the following methods:

  1. Equals: Compares two variables for equality.
  2. CompareTo: Compares two variables and returns an integer indicating their relative values.
  3. Contains: Checks if a variable contains a specified value.
  4. StartsWith: Checks if a variable starts with a specified value.
  5. EndsWith: Checks if a variable ends with a specified value.
  6. Length: Returns the length of a variable.
  7. IsNullOrEmpty: Checks if a variable is null or empty.
  8. IsNullOrWhiteSpace: Checks if a variable is null, empty, or contains only whitespace.
  9. Matches: Checks if a variable matches a specified regular expression pattern.
  10. In: Checks if a variable is present in a specified collection.

These methods can be used with different variable types, such as strings, numbers, arrays, etc., to perform various validation checks.









		
Leave a Reply 
Your email address will not be published. Required fields are marked *





 


 


	



DJANGO



DJANGO



DJANGO



DJANGO






	

	






	
		

			

				

					
Similar Posts
					

						

							

								


















							

						

					

				

			

		

		

		

		
Leave a Reply 
Your email address will not be published. Required fields are marked *