Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Mark every 20k records when exporting

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.

2 Replies
Digvijay_Singh

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

sergio0592
Specialist III
Specialist III

Hi,

Try to add an expression with :

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