Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you share some sample, image of output etc to understand more about the problem?
Hi,
Try to add an expression with :
if(Mod(Rowno(),20000)=0;1;0)