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.
Hey there!
Please use the following in your where clause:
[Material] = '@Mat_value'
That should work.
Kind regards,
Theo
+2
Same output (blank)
+2
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).
+2
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.