Skip to main content
Nintex Community Menu Bar

Output from Query from Excel wrong ?


Forum|alt.badge.img+2

I use query from excel as below.

 

25793iBF10092265542D60.jpg 

output show blank.

 

But if I have as below. output as true.

 

25794iAEFA184EC8841ADE.jpg 

But want use variable in where clause.

 

Please guide me about it.

 

 

 

Translate
Did this topic help you find an answer to your question?

6 replies

Hey there!

 

Please use the following in your where clause:

 

[Material] = '@Mat_value'

 

That should work.

 

Kind regards,

Theo

Translate

Forum|alt.badge.img+2
  • Author
  • Rookie
  • 7 replies
  • August 29, 2022

Same output (blank)

Translate

Forum|alt.badge.img+2
  • Author
  • Rookie
  • 7 replies
  • August 29, 2022

How to solve it?

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

Forum|alt.badge.img+2
  • Author
  • Rookie
  • 7 replies
  • August 29, 2022

File input as attached.

 

Thank you.

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings