1 2 Previous Next 18 Replies Latest reply on Jun 14, 2018 2:00 AM by Lavy Friedman

    Create field in 1 table based on a different table

    Lavy Friedman

      Hi all,

       

      So I have 2 tables that are connected, table 1-record_ assesstestexecution:

      Screen Shot 2018-06-12 at 2.01.34 PM.png

      and Table 2- record_assessrepetition:

      Screen Shot 2018-06-12 at 2.08.35 PM.png

      So as you can see, every test execution id has several repetition ids linked to it.

      What I need to do is create a column in table 1 (lets call it "successful_test"), that receives the value "TRUE" if any of the repetitions linked to that specific test execution id have the value "TRUE" in that selected column, and "FALSE" otherwise.

      So for example test execution #1 has 4 selected repetitions and 1 unselected, so it will recieve the value TRUE.

       

      I have tried all sorts of methods with grouping and the fixed function, but nothing really worked. I'm sorry I can't attach the workbook.

       

      Thanks in advance:)

        1 2 Previous Next