There are lots of capabilities and strategies inside Qlik Sense that one would possibly neglect to recall when a problem is introduced. These capabilities can all the time use sensible examples of implementation and use case eventualities. Let’s take a look at the FROM_FIELD operate in Qlik Sense.
Load * FROM_FIELD
Load * FROM_FIELD is a helpful script operate in Qlik Sense that lets you parse the contents of a single column into many columns or rows. Listed below are some sensible examples:
- Tackle: Shopper Addresses are captured inside a single column on the supply system.
- Monetary: Chart of Accounts – Permits the jagged hierarchy of the chart of accounts to be learn from a single area and transposed to rows or columns.
- Gross sales: Invoice of Materials – Traces on an Bill throughout the Stock Administration Programs a Invoice of Materials can have a jagged hierarchy saved inside a single column throughout the supply system. It will then want separated into columns for reporting functions.
- Web site: Knowledge captured inside a single column and desires introduced in a number of columns.
This script instance gives the Tackle parsed out into columns:
Tackle: 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 (Tackle, CustomerData) (txt, utf8, no labels, delimiter is '|', msq);
This instance script gives the Net Knowledge parsed out into rows.
Web 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 (Web sites, URLs) (txt, utf8, no labels, delimiter is '|', filters(Transpose()));
Alternatively, this may then be used as a filter throughout the software, not only for output in a chart or graph.
Qlik Sense provides flexibility and creativity to beat the challenges of information and the way greatest to current it. This instance of the FROM_FIELD operate will hopefully assist spark a artistic answer to your subsequent problem.
Hold Studying: Cumulative Sum Expression Writing In Qlik Sense