Description

Table MVKE

I want to extract a sku with sales organization 260 (3 digits) 

=260, =0260, LIKE 260, <=261 --> failing

But if I feel >= 0260 or >0260 or LIKE 26* --> working

The requirement is to use the "=" indicator or the "IN"

Applies To

Query

Cause

Wrong format used in the criteria

Solution

Run a Query from that table with the Sales Org as an output. For instance one Query with no criteria an a limit of 2 records or an criteria working

Open the Excel data file and check the format of the extraction, we can notice one blank space at the end:

In the script, add a space at the end of the Sales Org when using "="

Or 
when using the " IN " deactivate the trim training spaces option after adding one space for each Sales Org of the column
 

Or

Activate the Post-Pad with spaces

Additional Information

https://docs.winshuttle.com/studio-en-20-2-online-help-studio-with-connect/define-criteria.htm

https://docs.winshuttle.com/studio-en-20-2-online-help-studio-with-connect/change-padding-options.htm