5 Replies Latest reply: Jun 13, 2013 10:56 AM by Alan Farrell RSS

    Create field that contains all combinations of two fields

      Hello.

       

      I am trying to create a new table from two other fields by taking all combinations of them.

       

      I have one field, CODE in the table DEFINITION_CODE that maps to field PHENO_VALUE in table PHENOTYPES via the id PHENO_DEFINITION_CODE_ID. These maps to a specific DONOR_ID in the table DONOR. (See the attached example)

       

      CODE contains phenotype codes (A, C, Fya, Ena and so on) and PHENO_VALUE contains values that these CODES can have (POSITIVE, NEGATIVE, INCONCLUSIVE).

       

      I want to take these two fields and generate a new field with all combinations (A+,A-,A?,C+,C-,C?,Fya+ and so on).

       

       

      I am attaching an example with the fields.

       

      Thank you for any help!

       

      /Databyran