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.