Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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?
Hi Robert,
Exactly!
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?
They have data sets with similar fields.
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
Thank you, Robert for the help. I will do that.
No problem, good luck