Skip to main content
  • EN

Hello,

How can I use the values from two fields to match against another dataset?
 

image 1, filtered port

I have a test filter, which filters out all items that contain ‘FeatureWriter’ in the transformer_parameter_value field, 

I now want to take the items from the unfiltered port,

Image 2, Unfiltered port.

and match these against the initiator_workspaceId AND transfomer_id items from the filtered port (image 1). 

I do not want to do a row by row comparison, I want to match all items that exist in the filtered output (image 1) against all items in the unfiltered port (image 2). If they have a matching combination of both the initiator_workspaceId AND transfomer_id.


I attempted to use a featureJoiner to achieve this:
 

image 3. failed attempt

 

but as can be seen, there should be 3 items with transformer_id 81, but unfortunately some of the items were merged, which I do not want. I want all items from the filtered list and unfiltered list to be in the output, without any sort of merging. 


 

How can this be done?


Thanks for the help. 

My solution:

Using InlinQuerier, 
 

WITH FilteredFeatureWriters AS (
    SELECT 
        transformer_id,
        initiator_workspaceID
    FROM 
        output
    WHERE 
        LOWER(transformer_parameter_value) LIKE '%featurewriter%'
)

SELECT *
FROM 
    output
WHERE 
    (transformer_id, initiator_workspaceID) IN (SELECT transformer_id, initiator_workspaceID FROM FilteredFeatureWriters);

 

Reply


Community Stats

30,351
Posts
115,341
Replies
38,082
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.