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
Translate
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).
Translate
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:
Translate
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.