Creating a table - Set Analysis

LNP — Thu, 03 Jun 2021 21:28:39 GMT

I have a data set that can be simplified to four dimensions (RecordID, FM Hand, FMNumber and FMBarcode).

I wish to use a filter pane to select multiple different FMBarcodes.

The resulting table I want to create, shows one row for each filtered FMBarcode, and then in subsequent columns, the corresponding FMHand, FMNumber and RecordID. So far not a problem!

However, each record contains FMBarcodes that have a "Left" FMHand and a "Right" FMHand. I wish the final column to show the FMBarcode that has the same RecordID and same FMNumber as the first-column FMBarcode, but has the opposite FMHand.

I suspect that this is a set analysis problem. I have tried what I thought might be a slightly simpler approach, to list columns with the "Left" and "Right" FMHands, but the result meshes all possible FMNumber's with all possible RecordID's, when what I want is only the possible FM number within an individual Record ID, per row for each selected FMBarcode.

MaxString({1<RecordID=P(RecordID)>*1<FMNumber=P(FMNumber)>*1<FMHand={"Right"}>}FMBarcode)

topic Creating a table - Set Analysis in App Development

Creating a table - Set Analysis