topic Re: Several csv files into separate sheets in QlikView

Several csv files into separate sheets

Wed, 11 Jun 2014 20:26:33 GMT

How do I import a .xls file per sheet?

For example, I have one .xls file that I have working for one sheet. I have a separate .xls file that I would like to import for another sheet. How do I do that so that both sheets aren't using the same .xls files?

Thanks.

Re: Several csv files into separate sheets

Wed, 11 Jun 2014 20:29:01 GMT

So you're trying to make it so that one file you import will be data for one sheet in your qvw, and the second file will be data for a second sheet in your qvw?

Re: Several csv files into separate sheets

Wed, 11 Jun 2014 20:31:27 GMT

Hi Robert,

Exactly!

Re: Several csv files into separate sheets

Wed, 11 Jun 2014 20:34:05 GMT

Would it be possible for you to just import the two tables and only reference them in their respective sheet? Or is the problem that they are data sets with similar fields?

Re: Several csv files into separate sheets

Wed, 11 Jun 2014 20:35:10 GMT

They have data sets with similar fields.

Re: Several csv files into separate sheets

Wed, 11 Jun 2014 20:38:40 GMT

To my knowledge, the easiest thing for you to do is to rename the fields in your data sets so that each field has a unique name. Otherwise you'll run into issues with a synthetic table between the two files you load in. Then, you can change any field names that display in your dashboard to fit your needs

Re: Several csv files into separate sheets

Wed, 11 Jun 2014 20:44:27 GMT

Thank you, Robert for the help. I will do that.

Re: Several csv files into separate sheets

Thu, 12 Jun 2014 12:00:20 GMT

No problem, good luck