How request Table01 Not In Table02

[EdevaldoJeronim]

I just need to request all TblMenuAplic.IdAplic Not In TblGrupoAplic.IdAplic for the TblGrupoAplic.IdGrupo = 1.

The table Example below:

I use the code below but the result should be TblMenuAplic.IdAplic 2 and 5 but the result very diferent.

Clear(MyTblTemp);;
ForAll(
          TblMenuAplic;
          Collect(
                     MyTblTemp;
                     Filter(
                             TblGrupoAplic;
                             !(IdAplic in Text(TblMenuAplic[@IdAplic]));IdGrupo = 1
                     )
            )

)

[EdevaldoJeronim · Accepted solution]

All

I solved this problem using the code below, thank you.

Clear(MyTblTemp);;
Clear(MyTblTemp1);;
ClearCollect(MyTblTemp;Filter(TblMenuAplic;IdAplic > 0));;
ClearCollect(MyTblTemp1;Filter(TblGrupoAplic;IdGrupo = CbnGrupo.Selected.IdGrupo));;
ForAll(
MyTblTemp1;
RemoveIf(MyTblTemp;IdAplic = MyTblTemp1[@IdAplic])
)

[alrez]

Hi,

Thanks for your follow up post! I am glad that you were able to get this figured out. Hopefully this will prove to be useful to future communities users.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.