Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you use this and check the record count:
LOAD *, Recno() As RecCnt;
SQL Select * FROM table;
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
Hi Qlikview Team,
Anyone can please help us?
Regards,
Gunjesh Joshi
How are you counting the rows in both the sources? Like i mean in qlikview and in salesforce how are you counting rows?