4 Replies Latest reply: Jul 17, 2015 4:40 AM by Sasidhar Parupudi RSS

    Using a loop to load multiple scores for each record

      Hi have an Excel database with the following columns:

       

      RecordID; {ScoreA}; {ScoreB}; {ScoreC}; ....

       

      The {ScoreA}, {ScoreB} etc will be the description of the scores with the score values in each column and won't be 'ScoreA', 'ScoreB', etc.

       

      I want to load the data so that for each Record ID, the score value is linked to the score description.  I can use:

       

      LOAD RecordID,

          {ScoreA} as score,

          'ScoreA' as ScoreType

      FROM ...

       

      LOAD RecordID,

          {ScoreB} as score,

          'ScoreB' as ScoreType

      FROM ...

       

      ...

       

      How do I use a loop to load the data more elegantly?