The Qlik Sense FROM FIELD Serve as

[ad_1]

There are lots of purposes and methods inside of Qlik Sense that one may omit to recall when a problem is gifted. Those purposes can all the time use sensible examples of implementation and use case situations. 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:

  • Cope with: Shopper Addresses are captured inside of a unmarried column at the supply gadget.
  • 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 – Strains on an Bill inside the Stock Control Methods a Invoice of Subject matter may have a jagged hierarchy saved inside of a unmarried column inside the supply gadget.  This will likely then want separated into columns for reporting functions.
  • Web site: Information captured inside of a unmarried column and desires offered in more than one columns.

Columns

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

Cope 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 (Cope 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 Information 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

Then again, this may then be used as a clear out inside the utility, now not 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 perfect to provide it.  This case of the FROM_FIELD serve as will optimistically lend a hand spark an inventive resolution in your subsequent problem.

Stay Studying: Cumulative Sum Expression Writing In Qlik Sense



[ad_2]

Supply hyperlink


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *