Extracting SQL table values column wise and iteration/row wise under individual variables

I have a SQL table lets say Column A, Column B, Column C, Column D with some values of 20 rows. I was able to create the headers of these tables as variables and pull the whole table of 20 rows. I want to do iteration step just like we do on excel so that I can cross compare the values with other table.

This is high priority for me, please reach out to me on tlwm_sandy@yahoo.co.in if anyone can. It will help me a lot, thanks.

Hi,
you have to create a step "Query Database", where you insert a standard SELECT. In Variable Map you have to set which column from SELECT will be mapped to which variable in robot. Then it works like any other Loop.


BR, Pavel Vraj

First of all, thank you so much brother.

Lets say below is table 1 and table name is "Students Details"

Name	Subject	Grade
Sam	Boilogy	A
Bill	Physics	B
Mark	Chemistry	A
Paul	Physics	A
Kevin	Maths	A
John	Boilogy	B
James	Maths	B

I am trying to pull or save some rows as an individual variable. For example: I would like to pull the entire rows from the table where column value "Subject" is "Maths"

Kevin	Maths	A
James	Maths	B

"Subject" is "Physics"

Bill	Physics	B
Paul	Physics	A

I would like to save these above 2 tables as variables separately(not as tables in SQL Database), so that I could use the above 2 tables to loop and perform other processes like validation.


Another case is to use the subject and name value of table 1 "Students Details" to compare with another table 2 "Students Location". So that base on this the remaining task has to be done, like inputting these values on web application

Name	Subject	City
Bill	Physics	New York
Martha	Chemistry	Los Angeles
Paul	Physics	Seattle
Michael	Maths	Boston
Thomas	Physics	Atlanta

Thanks in advance _/|\_

Sorry, I thought had to add some more steps in between. I just realized it can be done using the SQL query itself. Thanks.