Mark every 20k records when exporting

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Good day,

I am new to the Qlikview world and for the time being self-taught, since I do not have courses completed. I have a question about exporting files, since in doing so I leave a mark every 20,000 records. That is, for example, export a file that contains Ecuador telephone numbers (approximately 1 million), with a prefix of 12 digits long, and when exporting it every 20k, it leaves me a number with 13 digits. I have researched about it and I have not found anything to help me.

Basically the problem arises because I need to analyze bases of numbers and then export them to upload them to a unix system that detects that brand as a strange character.

In advance I am very grateful for your help and response.

Greetings.

Re: Mark every 20k records when exporting

Digvijay_Singh — Mon, 26 Feb 2018 18:33:13 GMT

Can you share some sample, image of output etc to understand more about the problem?

Re: Mark every 20k records when exporting

sergio0592 — Mon, 26 Feb 2018 19:09:15 GMT

Hi,

Try to add an expression with :

if(Mod(Rowno(),20000)=0;1;0)

topic Re: Mark every 20k records when exporting in QlikView

Mark every 20k records when exporting

Re: Mark every 20k records when exporting

Re: Mark every 20k records when exporting