where & and clause in script

[#1]

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

[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?

[#3]

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');

[#5]

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