Nested RemoveIf

[benyie]

Hi!

I have trouble figuring out these nested data connections.

I want to remove each record in "InsuranceSplit" if column "InsuranceTypeSplitId" exists in the table "InsuranceTypes" BUT only where  the column "ClientSplitId" is also equal to my variable vClientSplitId.

"InsuranceSplit"

"InsuranceTypes"

[Gochix · Accepted solution]

Hi @benyie ,

You can do something like this:

ForAll(InsuranceTypes,
RemoveIf(InsuranceSplit,InsuranceTypeSplitId = InsuranceTypes[@InsuranceTypeSplitId] && ClientSplitId = vClientSplitId))

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

[benyie]

Sorry @Gochix ! I was too quick, this actually didn't work as expected.

Because I first have to filter the table "InsuranceTypes" where the column ClientSplitId equals my vClientSplitId. After that I make the comparison and remove each record in "InsuranceSplit" if column "InsuranceTypeSplitId" exists in the filtered table "InsuranceTypes"

[Gochix]

Hi @benyie ,

the formula does exactly what you are asking. I’ve checked at my end before posting it and it worked fine. If this doesn’t work for you then could you explain what does the formula do so we can see what to adjust. 

[benyie]

@Gochix Oh now I see it worked.

I only read 500 records from database right now.

Since this operation takes several records I couldn't first see that anything happened at all.