Missing data while extraction from Salesforce to Qlikview

[gunjesh0310]

Hi ,

I am facing issue while pulling the data from Salesforce to Qlikview and Mode = Bulk, Batch size=500.

Almost Missing 3000 records during extraction.

when putting where condition  with Sales # for e.g.101,102,103 than these data are coming which are missing in full extract.

Load *;

sql select * from table;

Regards

Gunjesh Joshi

[vishsaggi]

Can you use this and check the record count:

LOAD *, Recno() As RecCnt;

SQL Select * FROM table;

[gunjesh0310]

Hi Vishwarath,

Thanks for reply.

But still the count are same and missing 3000(approx.) record.no change.

SF having 156459 records and I am getting in qlikview 153400 records.

Mode = Bulk is using.

Regards,

Gunjesh Joshi

[gunjesh0310]

Hi Qlikview Team,

Anyone can please help us?

Regards,

Gunjesh Joshi

[vishsaggi]

How are you counting the rows in both the sources? Like i mean in qlikview and in salesforce how are you counting rows?