Different behaviour between files with same data

[#1]

Hi all,

I have two files:

- the first one downloads data via ODBC from database server through some SQL instructions;

- the second one attaches to first one via binary instruction.

So data model is exactly the same.

I'm in a situation where if I apply an identical series of selections on both files then on a specific table in the first one I have a (correct) result, on the same table in the second one I see a subset of the first one (uncorrect).

The only thing I could see is that the complementary subset that's not loading has a column with null values, but also handling this (i.e. replacing the null value with a 0) nothing happens.

Unfortunately I can't upload any file because the original ones are too sensible and I'm not able to replicate with a sample dataset: so generally which could be the reasons of such behaviour?

Thanks, regards.

--

Marco Pikiri

[#2]

Just documented myself on section access, but I've not any need for it at now and so not implemented in my files.

Regards.

--

Marco Pikiri

[#3]

I'm trying continuosly to apply some variations on the scripts, reaching partial results depending for instance by the columns I include or exclude.

What kind of information could I transmit you to help you better analyze my problem?

Regards.

--

Marco Pikiri