7 Replies Latest reply: Oct 25, 2017 6:39 AM by Clever Anjos RSS

    How can I wildmatch CSV headers when loading data?

    Cristian Hainic

      Hi,

       

      When loading data from a CSV file, I want to do something like "LOAD timestamp*" to load all CSV columns named "timestamp1", "timestamp2" etc. from the file. I haven't found anything that simple yet. Is there a way to do this? If not, what would be the simplest workaround in your opinion?


      The reason I need wildmatching is because I load from multiple files and each has a different number of columns such as "timestamp2" or "timestamp36" etc. I don't know the exact number of columns with the same name (and different numbers) for each file, since that number varies from file to file.


      Thanks,


      Chris