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.
Output from Query from Excel wrong ?
+2Hey there!
Please use the following in your where clause:
[Material] = '@Mat_value'
That should work.
Kind regards,
Theo
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).
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.