Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
amaldgain
Partner - Contributor III
Partner - Contributor III

Create a CSV File

Hi All,

I want to create a CSV file through Nprinting without any header. I have a Straight Table with suppress header row. When I export in excel from that char, data in excel report like shows as chart (without header & first line blank). But when I make CSV report through Nprinting using Entity Report & Task, It is appear with first line Blank. How can I omit first blank line?

Regards
Amal
12 Replies
Anonymous
Not applicable

NPrinting 16 or 17?

amaldgain
Partner - Contributor III
Partner - Contributor III
Author

Hi Robin,

It is NPrinting 16.5 (SR5).

Regards
Amal
Anonymous
Not applicable

I just tried it with the same NPrinting Version, no problem at all.

I used Excel Export what do you mean by csv export?

amaldgain
Partner - Contributor III
Partner - Contributor III
Author

Hi Robin,

I want to output file as a CSV format.

How to Export QlikView Objects to CSV files

Regards
Amal
Daniel_Jenkins
Specialist III
Specialist III

Hi Amal,

Why not use PixelPerfect? See:no ehader Nprinting

HTH - Daniel.

Anonymous
Not applicable

Sorry, I didn't read you question proberly

You could also create a macro task after your report task that deletes the first line of your created csv.

Just search the web for

vbscript delete first row of csv

(I don't know if I am allowed to copy in the examples here)

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Like Daniel suggests -  use Pixel Perfect.

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
amaldgain
Partner - Contributor III
Partner - Contributor III
Author

Can I make output file as a .CSV?

Regards
Amal
Daniel_Jenkins
Specialist III
Specialist III

Yes.

HTH - Daniel.