I have a script for loading data, I have found that in a field that has leading zeros, which adds more zeros than it should, when I load it with just one record, the data it loads is '00002', But WHEN you load the entire table Add zeros '0000002', this load I have Automated, DUE to a load queue All tables by means of parameters
if you try with Len(...key) with both query, len is the same? I mean, maybe there are two rows with '00002' and '0000002', but the second is not included in the second query.
Maybe it will be useful if you do the same query on the db outside of Qlik
