How to create dependent file parameters in loadrunner?

Loadrunner

Scenario:

We have username and password to be parameterized in which password selected should be dependent on the username selected, means username and password should match.

Solution:

This can be achieved by creating dependent file parameters in loadrunner.

Step 1: Create 2 file parameters with names UserID & Password.
Step 2: Add 2 columns in each parameter and name them as UserID & Password.
Step 3: Add the input userid's and passwords to the respective columns in both the parameters.
Step 4: In the UserID parameter select column by name option and select the column UserID.
Step 5: In the UserID parameter select the option Sequential/Unique/Random for select next row.
Step 6: In the Password parameter select column by name option and select the column Password.
Step 7: In the Password parameter select the option Same line as UserID for select next row.

Now username and the corresponding password will be passed to the scripts.