topic Re: Replace if statement with set analysis in App Development

Replace if statement with set analysis

shirleyk — Tue, 21 May 2019 09:30:31 GMT

Hi all,

I have two isolated tables which contain a key logically link to each other (ID1 & ID2).

DataA:
Load * inline [
ID1, Value1
A, TestA
B, TestB
C, TestC
];

DataB:
Load * inline [
ID2, Value2
A, TestX
B, TestY
C, TestZ
];

My expected result table is like this:

ID1 Value1 Value2

A TestA TestX

B TestB TestY

C TestC TestZ

It can be done by using this expression in columne Value2.

=aggr(only(if (ID1=ID2, Value2)), ID1)

However, due to performance issue (actually no. of records is more than 10 thousands), may i know if it is possible to change the if statement to set analysis?

I have tired the followings but it only works when one ID1 is selected.

=aggr(only({$<ID2={'=ID1=ID2'}>} Value2), ID1)

Thanks a lot,

Shirley

Re: Replace if statement with set analysis

bramkn — Tue, 21 May 2019 09:40:07 GMT

ID2=p(ID1)

Re: Replace if statement with set analysis

Gysbert_Wassenaar — Tue, 21 May 2019 09:40:26 GMT

Rename field ID2 to ID1.

Re: Replace if statement with set analysis

shirleyk — Wed, 22 May 2019 00:22:03 GMT

Thanks for the prompt reply.
Due to some restrictions, i cannot rename to associate these 2 fields together in data model. The logic can only be implemented via UI.

Re: Replace if statement with set analysis

shirleyk — Wed, 22 May 2019 00:27:20 GMT

Thanks for the suggestion.

Tried ID2=P(ID1), but seems still doesn't work.