How to filter data in FME using an attribute from another port?

Hi ​@jugoslaviaa ,

Not clear the situation, could you please clarify where 'CLASS_FILTER_FIELD' and 'CLASS_FILTER_VALUE' shown in your screenshot come from?

Hi ​@takashi 

These attributes come from an Excel file that I am reading. CLASS, ASSETGROUP, and ASSETTYPE exist in my main data as part of the cus_cstype_id attribute; however, it is not exposed. 

​@takashi My idea was to use a FeatureJoiner and join on CLASS, ASSETGROUP, and ASSETTYPE, and then try to use the exposed @Value(CLASS_FILTER_FIELD)—because I saw that in a community answer for a different question.
However, it didn’t work.

​@jugoslaviaa

From your email I am not sure if my understanding is correct, which is as below:

You are joining or merging two datasets (which is what you mean by one port brings the  main features and the second port brings the cus_cstype_id).

My conclusion is after the merge, your output features should contain class, assetgroup, assettype and cus_cstype_id attributes for the features that are output from the JOINED port of the FeatureJoiner, provided the settings in your FeatureJoiner are properly set.

Let me know if this is case and then I can assist you further.

Happy FME:-) ing

Cheers

SRG

According to your screenshot, @Value(CLASS_FILTER_FIELD) returns the string ‘cus_cstype_id’, won’t return the value of attribute called ‘cus_cstype_id’. 

If the feature has unexposed attribute named ‘cus_cstype_id’ and you want to retrieve its value, @Value(@Value(CLASS_FILTER_FIELD)) will return your required value.

@Value(@Value(CLASS_FILTER_FIELD)) returns the same value of @Value(cus_cstype_id), if the value of CLASS_FILTER_FILED was ‘cus_cstype_id’ - the case of your screenshot.

​@takashi ​@raghavendrans 
I added further explanation and image how my data looks like where i  try join the excel or filter. 

The problem is i have to first use the value of CLASS_FILTER_FILED  which is cus_cstype_id to expose a future in another dataset. 

​@takashi I join the dataset with FeatureJoiner and the parameter looks like this 
 

With these my data get the CLASS_FILTER_FILED  and tried 3 methods to compare and see if the expose works and noone of them works. 


 

I think I have almost understood the situation, but I have one more question. Is the value of CLASS_FILTER_FIELD always 'cus_cstype_id', or could it be vary?

[Addition]

The values returned from @Value(@Value(CLASS_FIELD_VALUE)) and @Value(CLASS_FIELD_VALUE) can be assigned to new attributes with AttributeManager or AttributeCreator, could not be attribute names which will be exposed with AttributeExposer.

Unfortunately not always  'cus_cstype_id' it may be vary 

​@takashi all the objects are failing because @Value(@Value(CLASS_FILTER_FIELD))  is not exposed. See my screen shot above. I tried all 3 variation and none of them return any values

You don’t need to expose any attributes. Have you configured the workflow as I suggested?

​@takashi yes, i think so

It seems that @ at the head of the expression is missing.

@Value(@Value(CLASS_FILTER_FIELD))

​@takashi Very embarrassing! It works!
You can actually access the attribute with the Tester even if it’s not exposed?
Thanks a ton!