Find All Fields with missing or null values while loading a csv file

Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone,

I have a csv file which has some fields with missing values and I want to identify which all fields have missing values. I can also use as stored procedure to get the same content as of the excel file.

Can anyone suggest how I an achieve this using either CSV file or stored procedure.

I started with the following code using stored procedure.

OLEDB connection;

load *;

SQL ****** EXEC Stored procedure syntax*************;

But in the above syntax all null values disappear from the fields.

Thanks in advance.

Re: Find All Fields with missing or null values while loading a csv file

Fri, 07 Apr 2017 15:43:07 GMT

Hi,

Can somebody help

I need to find all the fields which have missing values while loading from csv file.

Thanks in advance

topic Re: Find All Fields with missing or null values while loading a csv file in QlikView

Find All Fields with missing or null values while loading a csv file

Re: Find All Fields with missing or null values while loading a csv file