Need to Capture Null value in List Box

[Anonymous]

Hi,

          I am having blank values in "Arrival Place" field, But when i import the same file into Qlikview, It is not showing "Empty row". Which means I need to figure out the Data where the "Arrival Place = Empty". I have attached screen shot and also Excel file for reference. Thank in advance.

[sunny_talwar · Accepted solution]

Try this script:

NULLASVALUE *;

SET NullValue = ' ';

Table:

LOAD Name,

    Department,

    [Arrival Place],

    [Departure Place],

    [Arrival Time],

    [Departure Time],

    [Total Journey Hours],

    Amount,

    [Booking Date]

FROM

Example1.xlsx

(ooxml, embedded labels, table is Sheet1);

[Anonymous]

Awesome, Thanks for your quick reply Sunny. Working Perfect.....