topic Re: Nprinting 18 csv headers in Qlik NPrinting

Nprinting 18 csv headers

xiuur2508 — Thu, 19 Mar 2020 20:06:31 GMT

Hello,

I need to delete headers from qlikview entity.

Everything were working fine with Nprinting 16 !
I shouldnt upgrade to 18...

So i need to extract a table as a csv.
How can i do that ?

The only way i found was using QlikEntity but i don't have any option to remove headers.

Thanks guys.

Re: Nprinting 18 csv headers

Lech_Miszkiewicz — Tue, 19 Feb 2019 07:26:06 GMT

You are right, currently there is only Entity report supporting CSV output.

Depending what are you using your CSV for, maybe you can use header line to produce "dummy" record which will not impact any further steps you are using it for.

like this, where i put as column headers 0 in values and some dummy values for dimensions:

Re: Nprinting 18 csv headers

xiuur2508 — Tue, 19 Feb 2019 07:50:38 GMT

Hello, thanks for the reply.

I used space to make dummy column.
But in my csv, i have a blank line and i really need to delete this line.

My csv has to start with values and not a blank line or my script will faill.

I saw a macro to delete this line, but i don't know how to use it. (And it's a workaround i don't want to use)

If i store csv directly from Qlikview?