Check if one list object is contained in another list object

Anonymous — Thu, 06 Jun 2019 20:53:06 GMT

Ciao All,

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......

thanks!

Re: Check if one list object is contained in another list object

Anonymous — Thu, 06 Jun 2019 20:54:36 GMT

please note that i am not good in java custom expression...so a good help would be very very appreciated