Match and check value from 1 single cell

Five Stars

Match and check value from 1 single cell

Hi Everybody,

 

I'm facing the need of checking the value of a column that match with a single cell from another column.

 

I'm working on Talend Free data preparation.

 

Scenario:

 

As I'm preparing a dataset containing lot of informations I need to check if the 10000 (example number) records of Location (for example , "Europe") have a match from a single value of another column's cell (like list of possible location (Europe, USA, Asia etc)).

 

It means that if I have a file with for expample only 1 location, and a file with list of location which has only 5 records ( like the five continents ) I need a function which will say : "Ok, the following column showing all the location has valide values because I found a corresponse inside the other column "

 

Is it possible? Having a match beetwin an entire column and a single cell?

 

Thanks

 

 

Six Stars

Re: Match and check value from 1 single cell

Hello,

If I am understanding your scenario here the location (Africa) from File1 matches with the record from file2.

if it matches then it should be valid...

 

location.PNG

 

what output you exactly wants?

 

Regards

Ganshyam