Data Oriented
Data Oriented
Overview: While working with Data, users often reach a point where they'll have to compare the data coming from one data source (Excel, CSV, Database, etc.) with another. In the article, we'll be discussing how we can carry out a One to N (1 to N) comparison in Leapwork using the Read Excel building blocks. In this scenario, we will have...
In Leapwork, you may be required to use Powershell scripts to be executed in scenarios specific to user requirements. Users can use the Command Line Block in Leapwork to run the PowerShell script which has been created for these user-specific scenarios. Whenever you want to trigger the PowerShell script from the Command Line, use the...
With Leapwork, there are instances when the user is required to perform the Text read and write operations on a text file like notepad. Users can achieve this functionality easily by using the command line building block in Leapwork. Users can trigger a PowerShell script using this block which will perform the read/write operations. In...
Overview: While performing automation, we might come across a scenario where we need to fetch/read any random value from an Excel sheet and provide the same to an application. These values can come from within the defined range of the Read Excel building block. With the help of this block, we can read the value for any random row from...
Overview: In one of our previous articles, we discussed how to perform a SELECT query through a Database block in Leapwork. In this article, we will learn how to perform a JOIN operation in Leapwork using a Database Block. To begin with, we need to first check some of...
In Database testing, a Join clause has a lot of significance since it allows the user to join or combine columns from one or more tables in a relational database. In Leapwork, users can perform different joins like Inner Join, Left Join, Right Join, Full Join, Cross Join, Self Join, etc. using the Database building block in the Data-Driven...
Windows PowerShell is mostly known as a command-line shell used to complete administrative tasks in Windows and the apps that run on it. It is also a scripting language that allows you to create cmdlets – lightweight commands to perform specific functions. Send-MailMessage is an example of a cmdlet to send emails from PowerShell. There...
Overview: While working with Data, users often reach a point where they'll have to compare the data coming from one data source (Excel, CSV, Database, etc.) with another. In the article, we'll be discussing how we can carry out an N to One (N to 1) comparison in Leapwork using the Read Excel building blocks. In this scenario, we will...