Null Values

[Anonymous]

I am importing data from a SQL Server table. The table has 426 records as follows:

There are no null values in the table above.

However when the table records are imported into a QV straight table, it contains some null values as follows:

What could be going on?  Please assist.

Regards

[vishsaggi]

How you are importing data from SQL server are you running a Select statement using SQL Select or from a text file?

[jonathandienst]

Is [Port Loading Date] a key field? In other words, does the field name exist in more than one table?

[Anonymous]

I am using SQL Select as follows:

My table view is as follows;

Thank you

[Anonymous]

Thanks Jonathan. My table view is as follows:

The field [Port Loading Calendar] exists in the main table (IndiaImports) and the calendar.

My SQL Select statement for import of data is as follows:

Regards

[jonathandienst · Accepted solution]

The table ImportPortLoadingCalendar contains values of portLoadingDate which are not in IndiaImports. Those dates will have nulls for all the values not present in IndiaImports.

[Anonymous]

Thanks Jonathan, that is the cause of the null values.  Managed to change everything to make it work