https://community.qlik.com/t5/QlikView/Import-data-from-csv/m-p/1542774#M745744 In the script add Where statement:<BR />Where isnum(EnterpriseRegistrationNo) Tue, 12 Feb 2019 08:45:11 GMT MindaugasBacius 2019-02-12T08:45:11Z https://community.qlik.com/t5/QlikView/Import-data-from-csv/m-p/1542767#M745743 <P>Hello everyone,</P><P>PFA,</P><P>Please assist me with importing the data from a csv file as attached and putting it into the correct columns. On the attached file, I have highlighted both original state and the expected state.</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Import-data-from-csv/m-p/1542767#M745743 zwyne 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Import-data-from-csv/m-p/1542774#M745744 In the script add Where statement:<BR />Where isnum(EnterpriseRegistrationNo) Tue, 12 Feb 2019 08:45:11 GMT https://community.qlik.com/t5/QlikView/Import-data-from-csv/m-p/1542774#M745744 MindaugasBacius 2019-02-12T08:45:11Z