9 Replies Latest reply: May 24, 2016 6:27 PM by Marco Wedel RSS

    Interesting challenge: How to create a real table from a list of field names?

    John Blomqvist

      Hi all,

       

      Let's say I have a table like this:

       

      FieldNameDataFormatDependency
      OrderIDNumericNone
      OrderDateDatetimeNone
      CustomerIDStringNone
      CustomerNameStringNone
      DispatchDateDateOrderDate

       

      I would like to load the table above, and then create an actual 'real' table with fields from the FieldName column.

       

      The above table need can have any given number of fields. So for example at the moment it's 5, but tomorrow a user might add 3 more so it would be 8 fields.

       

      The 'real' table from above needs to reflect every field from the above table.

       

      Any idea how to do that please?

       

      The end result from the above example would be something like this:

       

      OrderIDOrderDateCustomerIDCustomerNameDispatchDate