Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

where & and clause in script

Hi,

I want that ORDER_RELEASE_TYPE_GID should pick ( 'ISO','DSO')

I had written below code but not sure its right or wrong.

Order_Release:

LEFT JOIN (SHIPMENT)

LOAD  ORDER_RELEASE_GID, 

              ORDER_RELEASE_TYPE_GID

    

FROM \\10.50.53.84\e$\Live\QvApp\Qvds\Order_Release.qvd (qvd)

where WildMatch (ORDER_RELEASE_GID ,'ALLANA/OCEAN.BR%');

//and (ORDER_RELEASE_TYPE_GID =( 'ISO','DSO'));

If the above code is wrong please send the correct code.

Regards

5 Replies
sunny_talwar

You are using a where clause for ORDER_RELEASE_GID only? Do you want both or just the one on ORDER_RELEASE_TYP_GID?

Not applicable
Author

Hi,

Please review by code and suggest is it correct.

data is not coming ORDER_RELEASE_TYPE_GID.

As i want ORDER_RELEASE_TYPE_GID should pick data of 'ISO' and 'DSO'.

Please find the below code.

SHIPMENT:

LOAD distinct SHIPMENT_GID,

   

     TRANSPORT_MODE_GID,

     SOURCE_LOCATION_GID

  

FROM

\\10.50.53.84\e$\Live\QvApp\Qvds\Shipment.qvd (qvd)

where WildMatch (TRANSPORT_MODE_GID, 'FLATBED');

left join (SHIPMENT)

LOAD distinct SHIPMENT_GID,

     SHIPMENT_REFNUM_QUAL_GID,

     SHIPMENT_REFNUM_VALUE ,

     DOMAIN_NAME

    

FROM

\\10.50.53.84\e$\Live\QvApp\Qvds\Shipment_refnum.qvd

(qvd)

where wildmatch (SHIPMENT_REFNUM_QUAL_GID, 'CONTAINER_NO')

and (DOMAIN_NAME = 'ALLANA/OCEAN')  ;

left join (SHIPMENT)

LOAD Distinct SHIPMENT_GID,

     STATUS_TYPE_GID,

     STATUS_VALUE_GID

     //DOMAIN_NAME,

FROM  

\\10.50.53.84\e$\Live\QvApp\Qvds\shipment_status.qvd

(qvd)

where wildmatch (STATUS_TYPE_GID, 'ALLANA/OCEAN.SHIPMENT_STATUS')

and (STATUS_VALUE_GID <> 'ALLANA/OCEAN.CANCELLED')  ;

VSOR:

LEFT JOIN (SHIPMENT)

LOAD Distinct SHIPMENT_GID,

     ORDER_RELEASE_GID

FROM \\10.50.53.84\e$\Live\QvApp\Qvds\VSOR.qvd (qvd)

where not WildMatch (ORDER_RELEASE_GID ,'ALLANA/OCEAN.BR%');

Order_Release:

LEFT JOIN (SHIPMENT)

LOAD  ORDER_RELEASE_GID, 

              ORDER_RELEASE_TYPE_GID,

     ORDER_RELEASE_XID as [DELIVERY ID]        

FROM \\10.50.53.84\e$\Live\QvApp\Qvds\Order_Release.qvd (qvd)

where WildMatch (ORDER_RELEASE_TYPE_GID = 'ISO','DSO');

Regards,

sunny_talwar

Check this. Only change I made was in the very last line of the code

FROM -> Where WildMatch (ORDER_RELEASE_TYPE_GID = 'ISO','DSO');

TO ->      Where WildMatch(ORDER_RELEASE_TYPE_GID, 'ISO','DSO');

Replace equal sign with a comma because within WildMatch function, you won't need an equal sign

SHIPMENT:

LOAD Distinct SHIPMENT_GID,

  TRANSPORT_MODE_GID,

  SOURCE_LOCATION_GID

FROM

\\10.50.53.84\e$\Live\QvApp\Qvds\Shipment.qvd (qvd)

Where WildMatch(TRANSPORT_MODE_GID, 'FLATBED');

Left Join (SHIPMENT)

LOAD Distinct SHIPMENT_GID,

  SHIPMENT_REFNUM_QUAL_GID,

  SHIPMENT_REFNUM_VALUE,

  DOMAIN_NAME

FROM

\\10.50.53.84\e$\Live\QvApp\Qvds\Shipment_refnum.qvd (qvd)

Where WildMatch(SHIPMENT_REFNUM_QUAL_GID, 'CONTAINER_NO') and (DOMAIN_NAME = 'ALLANA/OCEAN');

Left Join(SHIPMENT)

LOAD Distinct SHIPMENT_GID,

  STATUS_TYPE_GID,

  STATUS_VALUE_GID

FROM

\\10.50.53.84\e$\Live\QvApp\Qvds\shipment_status.qvd (qvd)

Where WildMatch(STATUS_TYPE_GID, 'ALLANA/OCEAN.SHIPMENT_STATUS') and (STATUS_VALUE_GID <> 'ALLANA/OCEAN.CANCELLED');

Left Join (SHIPMENT)

LOAD Distinct SHIPMENT_GID,

  ORDER_RELEASE_GID

FROM \\10.50.53.84\e$\Live\QvApp\Qvds\VSOR.qvd (qvd)

Where not WildMatch(ORDER_RELEASE_GID ,'ALLANA/OCEAN.BR%');

Left Join(SHIPMENT)

LOAD ORDER_RELEASE_GID,

  ORDER_RELEASE_TYPE_GID,

  ORDER_RELEASE_XID as [DELIVERY ID]      

FROM \\10.50.53.84\e$\Live\QvApp\Qvds\Order_Release.qvd (qvd)

Where WildMatch(ORDER_RELEASE_TYPE_GID, 'ISO','DSO');

Not applicable
Author

Hi,

Thanks..its working..

Regards

sunny_talwar

Great, please close this thread by marking correct and helpful answers

Qlik Community Tip: Marking Replies as Correct or Helpful