acces to array items like with Where fonction
Hello to all,
This new forum made me want to share something with you .
I chose this code which allows to find elements in a table by filtering as we would do with the Where function of Select.
var myTable := ["Jacques", "Marie", "Leon", "Nadine", "Marie-Claire", "Sylvain"]; myTable[like "Marie"]
result of formula :
I'm obviously not getting the logic behind all this so I'm putting this out there.
Here is my code:
let xH1 := allhito1; let xH2 := allhito2; xH1[var ah1 := this; count(xH2[= ah1]) = 0]
The two fields (allhito1 & 2) are the results of select statements.
Now taking the new formula from Jacques from below I thought it would do the subtraction of xH2 records from xH1, but I get the same number of records in xH1. If change xH2 to hard coded numbers that are in xH1, then they get subtracted properly.
I think I need to add a var section to count(xH2...) but my little brain can't figure it out.
Thanks all for your help.