- #4
If it is an old version of power query, just download a new one and install it. But are you using Excel 2010? If so, this option doesn't exist at all. You need to create the query, don't load to excel and just make the connection. Then go I to power pivot and select existing connections and find the query there. Just go through the wizard to import the data
- #6
when you say "power pivot wizard", are you starting with "Existing Connections"? That is how you should do it. How confident am I it wont crash? Given it has crashed in there scenario, I am not confident at all. Your software is 6 years old and superseded by 2 complete version releases. Time to upgrade (although I realise that may not be in your control).
- #8
click on the power pivot window => Design => existing connections. That is correct. Best options are Better still, do all of the above You could try to do it in Power BI Desktop, but that may not meet your needs
1. get more PC memory - I consider 8GB to be the minimum if you use Power Pivot
2. get the 64 bit version of Office (this can be
difficult in some companies)
3. upgrade to Excel 2016
Last edited: Oct 20, 2016
QlikView App Dev
Discussion Board for collaboration related to QlikView App Development.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
2016-11-29 07:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi All,
I am having a requirement like ;
I have a data model ,from there i need to export each table data to a excel report.Each table may contain N number of fields.
Example: I have a data model like below:
I need to export Master Calednder,Products,etc.. Tables into excel data report.So kindly help me on this.
Thanks & Regards,
Anjaneyulu
- export data model
- All forum topics
- Previous Topic
- Next Topic
1 Solution
2016-11-29 07:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
hi
this part of script
will export all the tables in the model into csv files
let vtables = NoOfTables();
for i=0 to $(vtables)-1
let vTable = TableName($(i));
store $(vTable) into $(vTable).csv (txt,delimiter is ',');
NEXT
6 Replies
2016-11-29 07:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi..,
we can't export entire data model at the same time....but we can export each table data separately...
i hope this is helpful to you..
Create a..table box with the data you have in your table,
then send to excel.....each table separately.
2016-11-29 07:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
hi
this part of script
will export all the tables in the model into csv files
let vtables = NoOfTables();
for i=0 to $(vtables)-1
let vTable = TableName($(i));
store $(vTable) into $(vTable).csv (txt,delimiter is ',');
NEXT
2016-12-01 04:42 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi Liron,
Thanks for your Information.It's more easiest approach than what Chanty4U provided for generating the excel data from a original qvw file.
Thanks alot once again.
Regards,
Anjaneyulu
- new_to_qlikview
- new to qlikview
- qlikview_scripting
- qlikview_layout_visuali…
- qlikview_creating_analy…
- qlikview
- script
- chart
- expression
- date
- load
- table
- set_analysis
- expressions
- macro
- analysis
- scripting
- pivot
- set
- dimension
- Forums
- Analytics
- New to Qlik Sense
- Move to SaaS
- Alerting
- App Development
-
Data Integration
- Qlik Application Automation
- Catalog and Lineage
- Qlik Cloud Data Integration
- Qlik Compose for Data Lakes
- Qlik Compose for Data Warehouses
- Qlik Gold Client
- Qlik Enterprise Manager
- Qlik Replicate
-
Forums by Product
- Products (A-Z)
- Groups
- Industry Groups
- Epic Developers
-
Healthcare
- Healthcare
- Healthcare
- Public Sector
- Public Sector
- Public Sector
- HSBC Private
- Location and Language Groups
- Brasil
- Brasil
- Brasil
-
Bulgaria
- Bulgaria
- Bulgaria
-
Chile
- Chile
- Chile
- Deutsche
- Español
- Francophones
- Francophones
- Francophones
- Italian Partners
- Japan
- Japan
- Japan
- Japan
- Japan Healthcare
- Japan Healthcare
- Japan Healthcare
-
Japan Support
- Japan Support
- Japan Support
- Kommun
- Komunita - CZ & SK
- Mexico
- Mexico
- Mexico
- OEM Partners España
- Россия и СНГ
- Россия и СНГ
- Россия и СНГ
- Partner España
- Portugal
- Portugal Partners
- UK
-
Эффективность бизнеса с Qlik
- Эффективность бизнеса с Qlik
- Эффективность бизнеса с Qlik
- Brasil
-
Topic Groups
-
Deployment Framework
- Deployment Framework
- Deployment Framework
- Monitoring & Administration
- Monitoring & Administration
- Monitoring & Administration
- Monitoring & Administration
- QlikBug
- QlikView to Qlik Sense
- QlikView to Qlik Sense
-
Scalability
- Scalability
- Scalability
- Design Partnership Program
-
Deployment Framework
-
Leader Groups
- Moderators
- Community MVPs
- Luminaries
- Industry Groups
-
More
- Job Board
- Video Transcripts
- Analytics