Importing Csv files as multiple tables RRS feed

  • Question

  • Hello,
    I'm importing multiple CSV files using get data from folder. Each file contains entirely different set of information and I'm not intending to combine them. Instead, I would like to create tables corresponding to each csv file in a single step without adding new query manually from each file. i.e I have X.csv, Y.csv, Z.csv, and eventually I need to create tables X, Y, Z.

    Sunday, December 31, 2017 4:26 PM


All replies

  • It's not possible to create multiple tables as such from 1 query. It can be done as nested tables, but most probably that is not what you are looking for.

    You may want to vote for this idea.

    Sunday, December 31, 2017 8:29 PM
  • You can get multiple tables in a query only, but you can not load them into workbook or model as it does not make any sense.

    Here is example I got:

    In this case I import multiple csv files from folder and convert them into different tables.

    Kind regards,

    Tom Sun

    Wednesday, January 3, 2018 6:00 AM