There are numerous features and strategies inside Qlik Sense that one may overlook to recall when a problem is introduced. These features can all the time use sensible examples of implementation and use case eventualities. Let’s take a look at the FROM_FIELD perform in Qlik Sense.

Load * FROM_FIELD

Load * FROM_FIELD is a helpful script perform in Qlik Sense that permits you to parse the contents of a single column into many columns or rows. Listed here 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 – Strains on an Bill inside the Stock Administration Techniques a Invoice of Materials can have a jagged hierarchy saved inside a single column inside 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.

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);

Pattern Output:

Rows

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()));

Pattern Output:

Alternatively, this may then be used as a filter inside the utility, not only for output in a chart or graph.

Conclusion

Qlik Sense affords flexibility and creativity to beat the challenges of knowledge and the way greatest to current it.  This instance of the FROM_FIELD perform will hopefully assist spark a inventive answer to your subsequent problem.

Preserve Studying: Cumulative Sum Expression Writing In Qlik Sense