There are lots of functions and methods within Qlik Sense that a person may forget to remember when a difficulty exists. These functions can constantly utilize useful examples of application and utilize case circumstances. Let’s take a look at the FROM_FIELD function in Qlik Sense.
Load * FROM_FIELD
Load * FROM_FIELD is a beneficial script function in Qlik Sense that enables you to parse the contents of a single column into lots of columns or rows. Here are some useful examples:
- Address: Customer Addresses are recorded within a single column on the source system.
- Financial: Chart of Accounts– Permits the rugged hierarchy of the chart of accounts to be checked out from a single field and shifted to rows or columns.
- Sales: Expense of Product– Lines on a Billing within the Stock Management Systems a Costs of Product can have a rugged hierarchy saved within a single column within the source system. This will then require separated into columns for reporting functions.
- Site: Data recorded within a single column and requires provided in numerous columns.
This script example offers the Address parsed out into columns:
Address: Load * Inline [ Customer_ID, CustomerData 1101, 1101|Catering Service|25648 Fisherman Drive|Bellevue|NE|68005|United States 1102, 1102|Wedding Venue|PO Box 354 RW|Portsmouth|NH|03801|United States ];. Columns:. Load *. FROM_FIELD (Address, CustomerData). ( txt, utf8, no labels, delimiter is'|', msq);
This example script offers the Web Information parsed out into rows.
Sites:. Load * Inline [ Website_ID, URLs 2546478SW$@265, www.cnn.com|www.foxnews.com|www.usatoday.com|www.nytimes.com 152478ER%^&154, www.google.com|www.snapchat.com|www.facebook.com|www.twitter.com ];. Rows:. Load *. FROM_FIELD (Sites, URLs). ( txt, utf8, no labels, delimiter is'|', filters( Transpose()));
Additionally, this can then be utilized as a filter within the application, not simply for output in a chart or chart.
Qlik Sense uses versatility and imagination to conquer the difficulties of information and how finest to provide it. This example of the FROM_FIELD function will ideally assist stimulate an innovative option to your next difficulty.
Keep Reading: Cumulative Amount Expression Composing In Qlik Sense