topic Re: where & and clause in script in QlikView

where & and clause in script

Fri, 29 Apr 2016 11:28:25 GMT

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

Re: where & and clause in script

sunny_talwar — Fri, 29 Apr 2016 17:13:04 GMT

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

Re: where & and clause in script

Thu, 05 May 2016 06:46:11 GMT

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,

Re: where & and clause in script

sunny_talwar — Thu, 05 May 2016 19:06:38 GMT

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

Re: where & and clause in script

Fri, 06 May 2016 11:30:13 GMT

Hi,

Thanks..its working..

Regards

Re: where & and clause in script

sunny_talwar — Fri, 06 May 2016 15:42:28 GMT

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

Qlik Community Tip: Marking Replies as Correct or Helpful