Hey, I am a little lost with your notes but if you want to create the flag that is going to say 'yes' when the Value2 exists in Value1 and says 'no' when Value2 doesn't exist in Value1 you can do something like this:
T1: LOAD NAME, VALUE1, VALUE2 FROM [lib://Desktop/Book1.xlsx] (ooxml, embedded labels, table is Sheet1);
T2: Load NAME, 'yes' as Flag Resident T1 Where Exists(VALUE1,VALUE2);
Load NAME, 'no' as Flag Resident T1 Where not Exists(VALUE1,VALUE2);
In truth, I don't have such NAME column and I don't know if open a new question topic might be better than continue here. I think that explain here its better so anyone can see the suggestions above and simply do the required corrections.
Marcelo, did Syed's post help you get what you needed? If so, do not forget to come back to the thread and use the Accept as Solution button on that post to give credit for the help and let other Community Members know that worked. If you are still working on things, leave an update as to what you still need at this point.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
First of all, sorry for the silence. Last days I was involved in other jobs and only now could come back for this problem.
Secondly, my real databank is very complex and I'm afraid that this AUTONUMBER function can cause some problems to my variables. Also, I noted that the COUNT(Flag) table in Syed's solution is summing 14 and I wanted it summed 10 (since VALUE1 has only 10 values).
Now, I tried this script and obtained the attached result. Except for the repeated rows with hyphens, it is working well.