Basically this is the scenario:
I have one input file which is do like that (first column is int, second string and 3rd list object):
ID | Name | Foods
1 | John | [Pizza, Pasta, Fruits]
2 | Jack | [Kebab, Fruits,]
Then, i have one second file like that:
Restaurant Name | Available Food
Restaurant 1 | [Kebab, Vegan, Fruits]
Restaurant 2 | [Kebab, Pizza]
Restaurant 3 | [Vegetables, Pizza, Pasta, Fruits, Kebab, Vegan]
I would like to underastand which restaurants "satisfy" the food request which is expressed in the 3rd column of the first file.
So in that case for example.
John - - - > only satisfied by Restaurant 3 , because the food requested by john is included in the available food of this restaurant (subset);
While Jack could eat in Restaurant 1 or Restaurant 3.
Please note thast the list of object are un-ordered..i would avoid to do lot of join......
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema