I use query from excel as below.
output show blank.
But if I have as below. output as true.
But want use variable in where clause.
Please guide me about it.
Page 1 / 1
Hey there!
Please use the following in your where clause:
[Material] = '@Mat_value'
That should work.
Kind regards,
Theo
Same output (blank)
How to solve it?
Could you perhaps attach a copy of the Excel file? Then I can test it and find a solution (it needn't be the whole file; maybe just an abbreviated copy with confidential information etc. removed).
File input as attached.
Thank you.
Please see the below solution (screenshots). This works! Please note that you set the wrong data type (CHAR) in your test (CHAR is only a single character). Just use the below and you're good to go:
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.