Tuesday, April 16, 2024

The Qlik Sense FROM FIELD Serve as

-


There are lots of purposes and strategies inside Qlik Sense that one would possibly omit to recall when a problem is gifted. Those purposes can at all times use sensible examples of implementation and use case eventualities. Let’s have a look at the FROM_FIELD serve as in Qlik Sense.

Load * FROM_FIELD

Load * FROM_FIELD is an invaluable script serve as in Qlik Sense that lets you parse the contents of a unmarried column into many columns or rows. Listed below are some sensible examples:

  • Deal with: Consumer Addresses are captured inside a unmarried column at the supply machine.
  • Monetary: Chart of Accounts – Lets in the jagged hierarchy of the chart of accounts to be learn from a unmarried box and transposed to rows or columns.
  • Gross sales: Invoice of Subject matter – Traces on an Bill throughout the Stock Control Programs a Invoice of Subject matter will have a jagged hierarchy saved inside a unmarried column throughout the supply machine.  This may increasingly then want separated into columns for reporting functions.
  • Website online: Knowledge captured inside a unmarried column and desires introduced in a couple of columns.

Columns

This script instance supplies the Deal with parsed out into columns:

Deal with:
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 (Deal with, CustomerData)
(txt, utf8, no labels, delimiter is '|', msq);

Pattern Output:

Output of Qlik Sense From Field Parse Columns

Rows

This case script supplies the Internet Knowledge parsed out into rows.

Internet 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 (Internet sites, URLs)
(txt, utf8, no labels, delimiter is '|', filters(Transpose()));

Pattern Output:

Output Qlik Sense From Field Parse Rows

On the other hand, it will then be used as a clear out throughout the utility, no longer only for output in a chart or graph.

Conclusion

Qlik Sense provides flexibility and creativity to triumph over the demanding situations of information and the way highest to give it.  This case of the FROM_FIELD serve as will optimistically lend a hand spark an artistic resolution on your subsequent problem.

Stay Studying: Cumulative Sum Expression Writing In Qlik Sense



LEAVE A REPLY

Please enter your comment!
Please enter your name here

Related Stories