Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fixed width in csv file

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

4 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

CSV file not excel

ToniKautto
Employee
Employee

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.

Not applicable
Author

Hi,

You can use like this.

Hope it helps!

111.PNG