5 Replies Latest reply: Feb 26, 2018 1:44 PM by norm fredericks RSS

    Cross Table with dynamic columns

    norm fredericks

      I have a records table (records) that I want to dynamically load individual columns based on another table (column).

      my original table has hundreds of columns.

       

      I need a cross table with only the specific columns in the column table.

       

      I am trying to create a loop but I have been unsuccessful.

      Is this even possible?

       

      Record  Table

      RecordIDABCDE
      4001abc 1
      4002qwe11 1
      4003asd 1 1
      4004zxc 1
      4005poi1 11
      4006lkj 1
      4007mnb 11
      4008rty1
      4009fgh11
      4010vbn1 1

       

      Column Table

      ColumnID
      B
      C
      E