{"id":740,"date":"2020-05-07T11:59:46","date_gmt":"2020-05-07T03:59:46","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=740"},"modified":"2020-05-07T11:59:46","modified_gmt":"2020-05-07T03:59:46","slug":"working-with-copies-of-the-same-data-sets-in-easy-excel-analysis-and-sql-data-analysis","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/05\/07\/working-with-copies-of-the-same-data-sets-in-easy-excel-analysis-and-sql-data-analysis\/","title":{"rendered":"Working with copies of the same data sets in Easy Excel Analysis and SQL Data Analysis"},"content":{"rendered":"

In\u00a0Easy Excel Analysis<\/a>\u00a0and\u00a0SQL Data Analysis<\/a>, you can create multiple analysis tables and\/or pivot tables by clicking on the Add analysis table<\/strong> and Add pivot table<\/strong> buttons on the toolbar.<\/p>\n

\"\"<\/p>\n

You do not need to re-import the Excel\/CSV file (in Easy Excel Analysis<\/a>) or re-run the query (in SQL Data Analysis<\/a>).\u00a0 Each analysis table and pivot table is independent, and you can customize the layout of each analysis and pivot tables to your needs.<\/p>\n

Because each analysis\/pivot table consumes memory resources, the number of tables you can create from each data set is determined by your settings.\u00a0 In Easy Excel Analysis<\/a>, this limit is set in the Data loading<\/strong> settings in the Import file<\/strong> wizard.<\/p>\n

\"\"<\/p>\n

In SQL Data Analysis<\/a>, the limit is set in the Data options<\/strong> settings.<\/p>\n

\"\"<\/p>\n

You can increase this limit if you need to be able to create more analysis\/pivot tables per data set, and your machine has the available memory capacity.<\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

In\u00a0Easy Excel Analysis\u00a0and\u00a0SQL Data Analysis, you can create multiple analysis tables and\/or pivot tables by clicking on the Add analysis table and Add pivot table buttons on the toolbar. You do not need to re-import the Excel\/CSV file (in Easy Excel Analysis) or re-run the query (in SQL Data Analysis).\u00a0 Each analysis table and pivot […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[82,86],"tags":[83,102,103,87],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/740"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=740"}],"version-history":[{"count":1,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/740\/revisions"}],"predecessor-version":[{"id":744,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/740\/revisions\/744"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}