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.
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?
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...
what output you exactly wants?