Comparing information within a table - extracting set lines

Discuss your general Proclaim related queries here.
Post Reply
HC_1
Posts: 10
Joined: Tue Dec 13, 2016 7:23 pm
Has thanked: 1 time

Comparing information within a table - extracting set lines

Post by HC_1 » Thu Dec 06, 2018 1:40 pm

Hi,

I need to be able to compare information across two lines of a table to see if a match exists and if so, then extract the result
i.e. if a table correspondent first name on line 2 matches the first name on line 4 then do "X" else do "Y", as part of a linked action.

Can anyone advise how I go about selecting the 2 lines/records of data within the maths that I want to compare in order to produce the action where a match is found? I will always want to pre-select the information lines/data rather than carry out a loop across all table records.

Thanks in advance

Post Reply