Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You are using a where clause for ORDER_RELEASE_GID only? Do you want both or just the one on ORDER_RELEASE_TYP_GID?
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,
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');
Hi,
Thanks..its working..
Regards
Great, please close this thread by marking correct and helpful answers