topic Re: Fixed width in csv file in Qlik NPrinting

Fixed width in csv file

Fri, 09 Sep 2016 10:13:29 GMT

Hi community,

I realise this si probably a npritning matter but anyway. Is it possible to via Qlikview or Nprinting set up columns with fixed width?

Just for the background story: We have a couple reports which is made in Data Integrator earlier buy should now be created with Qlikview and distributed via nprinting. The CSV fiels needs to be created with fixed width fields meaning that:

From column 1-5 = Client, from 15-25 accountnumber and in between that should be blankspaces in the output file.

Is this possible in qlikview/nprinting?

Cheers

Re: Fixed width in csv file

Anonymous — Fri, 09 Sep 2016 12:05:03 GMT

Hi, Niklas,

Is your required output report a .csv file or excel file? If it is a .csv file, what do you mean columns 1-5 =Client?

5 columns, but only one value? How is that possible? Dose that means, you want the output like:

"client,,,,,"? If you want some thing like that, I think you need to create empty column in .qvw file, and then you use export qlikview objects to csv here to get the .csv report. Or you can create .excel report, which you can control the columns that used in the report template.

Zhihong

Re: Fixed width in csv file

Fri, 09 Sep 2016 12:25:37 GMT

CSV file not excel

Re: Fixed width in csv file

ToniKautto — Fri, 09 Sep 2016 12:44:54 GMT

Not sure if I got this right, but attached you can find a way to generate one column where multiple fields are concatenated. Exporting this object will give a text file as you described.

Re: Fixed width in csv file

Fri, 09 Sep 2016 14:14:39 GMT

Hi,

You can use like this.

Hope it helps!