4 Replies Latest reply: Oct 23, 2017 2:12 PM by Stefan Wühl RSS

    Workaround for "Field names must be unique within table" error?

    Cristian Hainic

      Hi everyone,

       

      I have a CSV table with duplicate column names and Qlik refuses to load those fields, throwing the error from the title. Now, data-wise, I actually want all data within those columns to be loaded under the same field name. What can I do in the Data Load Editor to obtain this result?

       

      E.g., I have this piece of data:

      Name, Name, Name, Planet

      Chris, John, Mary, Earth

       

      I want to have it loaded in Qlik as it is and in the visualization use a *single* field name to refer to Chris, John and Mary. That field name would be "Name". Any thoughts on how I might achieve this?

       

      Thanks,

       

      Chris