How to get data table from Excel using select

Dear experts,
In Excel sheets
Name value
A 1
B 2
C 3

How can I get the results
If asking A 1
If asking b 2
Incase c 3

Using select query
Could anyone help me please?

Thanks in advance

1 Like

Hi @Abubakkar

You can use a lookup component for that one. Please check the component that I make. It is possible with this one:

Thanks and regards.


Check this… (17.4 KB)
Enter the Name and WriteLine gives you Value for it.

1 Like



1 Like

Thanks for the help experts.
If I get some input value 1 to 9
Then I need to get output in matrix.
Like this
1 2 3
4 5 6
7 8 9

Could anyone help me please?

1 Like

For both the questions one for values and one for matrix
here you go
hope itts resolved (15.7 KB)

Cheers @Abubakkar

kindly let know for any other queries
Cheers @Abubakkar