Skip to main content

Hi altruist, I am looking for an solution.

I have a road name list in three different feature type (two in shape files, one in excel). I have brought them together after editing schema to get a unique list of names. Now I want an automated way to validate a new name whether this is a new name or existing in the list. Can anyone kindly tell the ways of working around? Thanks in advance.

 

attached image: my workspace so far

Hi @smfks911​ 

Few questions that would clarify the workflow better.

Are these values coming from a parameter? If yes, you will need a ParamterFetcher transformer, DuplicateFilter

Are you trying to ensure that all the values are unique before writing?

If yes, I would recommend going through this article Data QA: Identifying Duplicate Attribute Value

 


Hi @smfks911​ 

Few questions that would clarify the workflow better.

Are these values coming from a parameter? If yes, you will need a ParamterFetcher transformer, DuplicateFilter

Are you trying to ensure that all the values are unique before writing?

If yes, I would recommend going through this article Data QA: Identifying Duplicate Attribute Value

 

Hi @rahulsharma​ , these values are coming different data sources/reader. As of now, the data written is cleaned and uniquely listed. But my next objective is to enable a system that will take an input road name from user and check if that exist in the final output table or not. Currently I am checking it by searching by typing in the visual display panel.


Reply