Check if one list object is contained in another list object

[Anonymous]

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!

[Anonymous]

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