Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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)