{"id":38536,"date":"2018-11-20T09:59:19","date_gmt":"2018-11-20T04:29:19","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38536"},"modified":"2021-12-07T11:19:59","modified_gmt":"2021-12-07T05:49:59","slug":"load-data-from-previously-loaded-data","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/","title":{"rendered":"Load Data From Previously Loaded Data – QlikView Resident & Preceding"},"content":{"rendered":"

By far, we have seen how to load data from files<\/a> <\/strong>and from databases<\/a><\/strong>. However, there is one more way of loading data i.e. how to load data from previously loaded data table in QlikView. In this tutorial, we will learn the reason for which data is loaded from previously loaded or already existing tables. Moreover, we will learn what is QlikView Resident Load and Preceding load in QlikView.<\/p>\n

So, let’s begin to load data from previously loaded data in QlikView.<\/p>\n

\"Load<\/a>

Load Data From Previously Loaded Data – QlikView Resident & Preceding<\/p><\/div>\n

How QlikView Load Data From Previously Loaded Data?<\/h3>\n

You know that when you load data from a database, it is done from a SELECT statement. And when we load data from external files, it is done by the LOAD statement. There is one more catch to it i.e. when SELECT statement is used, no calculations can perform on the data being loaded from the database. You cannot add any expressions within the SELECT statement because data will fetch as it is, and no functions are applicable to it.<\/span><\/span><\/p>\n

In such a scenario, to apply expressions on the loaded data, it needs to load again in the script<\/a><\/strong>. We can load it in two ways, either by using <\/span><\/span>a Resident<\/b><\/span><\/span> prefix with LOAD commonly called Resident Load or by using <\/span><\/span>Preceding<\/b><\/span><\/span> LOAD in a LOAD statement.<\/span><\/span><\/p>\n

Do you know What are QVD Files and how to create them?<\/a><\/strong><\/p>\n

QlikView Resident Load<\/h3>\n

The prefix Resident use to load data from previously loaded data table in the same script. Data can transform, and mathematical operations can perform through resident loading. QlikView Resident load takes fields and tables from an already loaded table within the same script. An example of a QlikView Resident load is,<\/span><\/span><\/p>\n

Country_population:<\/strong>
\nLOAD\u00a0Country,
\nCapital,
\n[Area(km.sq)],
\n[Population(mio)],
\n[Pop. Growth],
\nCurrency,
\nInflation,
\n[Official name of Country]
\nFROM
\n[Preceding Load\\Country_population.csv]
\n(txt,\u00a0codepage\u00a0is\u00a01252,\u00a0embedded\u00a0labels,\u00a0delimiter\u00a0is\u00a0‘,’,\u00a0msq);<\/p>\n

Calculated_Table:<\/strong>
\nload
\nCountry,
\nsum([Population(mio)])\/1565\u00a0as\u00a0percentage_Population
\nresident\u00a0Country_population\u00a0group\u00a0by\u00a0Country;<\/p>\n

drop\u00a0table\u00a0Country_population;<\/strong><\/p>\n

As you can see in this example, a table named \u2018Country_population\u2019 load first into the script than a new table name as \u2018Calculated_Table\u2019 create which calls a field \u2018Country\u2019 from the previous table<\/a><\/strong>, then Sum function apply on another field and at last the previous table is called using QlikView Resident Load.<\/span><\/span><\/p>\n

Follow this link to know How to apply QlikView Layout Theme?<\/a><\/strong><\/p>\n

Preceding Load in QlikView<\/h3>\n

Preceding load in QlikView loads data from the table present below the preceding load statement. This method of load data from previously loaded data is pretty useful. The QlikView Preceding statement does not need a location qualifier like From or Resident which indicates towards a data source. <\/span><\/span><\/p>\n

It has a fixed pattern i.e. evaluating the bottom-most statement first, then the one above it, then the one above and so on. One use of preceding load in QlikView is that you can place a load statement defining some calculations to perform on data at the bottom and then load data tables. By doing so, the script will evaluate the calculations first and apply it on the data in the table. <\/span><\/span><\/p>\n

Let us see an example of the Preceding load in QlikView.<\/span><\/span><\/p>\n

Preseding_Sample:<\/strong>
\nload
\nOfficeCountry,sum(Amount)\u00a0as\u00a0Amt
\ngroup\u00a0by\u00a0OfficeCountry;<\/p>\n

Office_Loc:
\nDirectory;
\nLOAD\u00a0Office,
\nOfficeAddress,
\nOfficePostalCode,
\nOfficeCity,
\nOfficeStateProvince,
\nOfficePhone,
\nOfficeFax,
\nOfficeCountry,
\nAmount
\nFROM
\nSampleData.txt
\n(txt,\u00a0codepage\u00a0is\u00a01252,\u00a0embedded\u00a0labels,\u00a0delimiter\u00a0is\u00a0‘\\t’,\u00a0msq);<\/p>\n

As is clear from this example, that the statement on the top is the Preceding statement which applies a function on the field from the table loaded in the statement below. During script execution, the statement at the bottom loaded first loading the table and then the statement above it will evaluate\u00a0and Sum on the field values of the field Amount will calculate.<\/span><\/span><\/p>\n

A preceding load in QlikView is a faster method to use than QlikView Resident load as it does not require a location qualifier. Also, using the Preceding load, you can apply multiple calculations and transformations through stacking up LOAD statements.<\/span><\/span><\/p>\n

So, this was all about How QlikView Load Data From Previously Loaded Data. Hope you like our explanation.<\/p>\n

Conclusion<\/h3>\n

In this tutorial, we discussed two ways in which we can load data from a previously loaded data table. The two ways are using predicates QlikView Resident Load and Preceding Load in QlikView in the LOAD and SELECT statements. Still, have a doubt feel free to ask in the comment box.<\/span><\/span><\/p>\n

Related Topic – QlikView Script Statements<\/a><\/strong><\/p>\n

Reference<\/a><\/strong><\/p>\n

By far, we have seen how to load data from files and from databases. However, there is one more way of loading data i.e. how to load data from previously loaded data table in...<\/p>\n","protected":false},"author":6,"featured_media":38543,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17269,17270,17237,16866,16865,17271],"class_list":["post-38536","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-loading-data-from-previously-loaded-data","tag-preceding-load-in-qlikview","tag-qlikview-load-data","tag-qlikview-preceding-load","tag-qlikview-resident-load","tag-resident-load-in-qlikview"],"yoast_head":"\nLoad Data From Previously Loaded Data - QlikView Resident & Preceding - DataFlair<\/title>\n<meta name=\"description\" content=\"How QlikView Load Data From Previously Loaded Data - QlikView Resident Load, Preceding Load in QlikView, Example of Resident & preceding statements\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Load Data From Previously Loaded Data - QlikView Resident & Preceding - DataFlair\" \/>\n<meta property=\"og:description\" content=\"How QlikView Load Data From Previously Loaded Data - QlikView Resident Load, Preceding Load in QlikView, Example of Resident & preceding statements\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-20T04:29:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:49:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/How-to-Load-Data-From-Previously-Loaded-Data-in-QlikView-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Load Data From Previously Loaded Data - QlikView Resident & Preceding - DataFlair","description":"How QlikView Load Data From Previously Loaded Data - QlikView Resident Load, Preceding Load in QlikView, Example of Resident & preceding statements","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/","og_locale":"en_US","og_type":"article","og_title":"Load Data From Previously Loaded Data - QlikView Resident & Preceding - DataFlair","og_description":"How QlikView Load Data From Previously Loaded Data - QlikView Resident Load, Preceding Load in QlikView, Example of Resident & preceding statements","og_url":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-20T04:29:19+00:00","article_modified_time":"2021-12-07T05:49:59+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/How-to-Load-Data-From-Previously-Loaded-Data-in-QlikView-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Load Data From Previously Loaded Data – QlikView Resident & Preceding","datePublished":"2018-11-20T04:29:19+00:00","dateModified":"2021-12-07T05:49:59+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/"},"wordCount":783,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/How-to-Load-Data-From-Previously-Loaded-Data-in-QlikView-01.jpg","keywords":["Loading Data From Previously Loaded Data","Preceding Load in QlikView","qlikview load data","QlikView Preceding Load","QlikView Resident Load","resident load in QLikView"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/","url":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/","name":"Load Data From Previously Loaded Data - QlikView Resident & Preceding - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/How-to-Load-Data-From-Previously-Loaded-Data-in-QlikView-01.jpg","datePublished":"2018-11-20T04:29:19+00:00","dateModified":"2021-12-07T05:49:59+00:00","description":"How QlikView Load Data From Previously Loaded Data - QlikView Resident Load, Preceding Load in QlikView, Example of Resident & preceding statements","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/How-to-Load-Data-From-Previously-Loaded-Data-in-QlikView-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/How-to-Load-Data-From-Previously-Loaded-Data-in-QlikView-01.jpg","width":1200,"height":628,"caption":"Load Data From Previously Loaded Data - QlikView Resident & Preceding"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/load-data-from-previously-loaded-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"QlikView Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlikview\/"},{"@type":"ListItem","position":3,"name":"Load Data From Previously Loaded Data – QlikView Resident & Preceding"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=38536"}],"version-history":[{"count":8,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38536\/revisions"}],"predecessor-version":[{"id":104929,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38536\/revisions\/104929"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/38543"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=38536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=38536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=38536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}