topic Re: How to Create Text file from multiple straight tables in NPrinting in Qlik NPrinting

How to Create Text file from multiple straight tables in NPrinting

zeeshanadeel — Tue, 12 Jan 2016 22:01:42 GMT

I would like to create a text file from two different charts / straight tables.

Both charts have different columns and values.

In this file I don't have to have any header row and the separator should be '~'.

I read that it can be achieved through PixelPerfect report but I don't know how. It would be great if someone please guide me on this. An example would be great. Thanks!

Re: How to Create Text file from multiple straight tables in NPrinting

Anonymous — Wed, 13 Jan 2016 12:27:23 GMT

Zeeshan,

When you say text file, do you mean PDF or something that you can delimit to another application

Is this a one time deal or recurring?

It would be very challenging to take you through the process to create a pixel perfect report in this forum post, however there are an abundance of resources available on this site to walk you through the process step by step.

If you navigate to Home and then to NPrinting, you can see everything you need to get started.

Re: How to Create Text file from multiple straight tables in NPrinting

zeeshanadeel — Wed, 13 Jan 2016 13:20:48 GMT

I want to generate *.txt file and it should have custom separator '~'

It will be a monthly file that I need to send to another system for import.

Re: How to Create Text file from multiple straight tables in NPrinting

Anonymous — Wed, 13 Jan 2016 13:54:36 GMT

Frank.Savino‌

Frank,

Is it possible to export out of NPrinting to a text file with a separate delimiter using Pixel Perfect. It appears to me that you can only go to PDF.

If so, do you have some direction on how to do that?

Re: How to Create Text file from multiple straight tables in NPrinting

Wed, 13 Jan 2016 15:32:29 GMT

I do not believe any of the templates support creating a file with a txt extension. Pixel Perfect does support rtf which may work and there is also using a word template to save it in a doc, docx extension.

These formats/extensions above support the overall requirement of being able to create the file but does not save with txt

Re: How to Create Text file from multiple straight tables in NPrinting

Wed, 13 Jan 2016 15:34:25 GMT

...and I guess there is always the ability of having the QlikView application write out the txt file

Re: How to Create Text file from multiple straight tables in NPrinting

zeeshanadeel — Wed, 13 Jan 2016 16:18:40 GMT

I wouldn't mind creating a CSV file as long as it can be generated from multiple charts.

I can always change the file extension through a batch file. Haven't thought about it thoroughly yet.

Re: How to Create Text file from multiple straight tables in NPrinting

Anonymous — Wed, 13 Jan 2016 17:59:19 GMT

So now, you are down to whether you need this automated or not. I don't know how complex your process is. You can create an NPrinting Excel template and extract your data from Qlikview and export it to a CSV file. It is not hard if you refer to the resource section I showed you in my previous post.

Or you can just click on Export to Excel from your QV object and manipulate your data and save as a CSV.

Only you can decide if you want to invest the time to automate the process

Re: How to Create Text file from multiple straight tables in NPrinting

Wed, 13 Jan 2016 19:15:06 GMT

Question - are you wanting 1 csv file for each table, or are you wanting 1 csv file containing the data from all of your tables.

If the answer to the first part is yes, then I would recommend Mike's suggestion. If the answer to the firat part is no, then I would suggest building an object in qlik that contains the data from all of the objects and then follow Mike's suggestion

Re: How to Create Text file from multiple straight tables in NPrinting

zeeshanadeel — Wed, 13 Jan 2016 21:17:00 GMT

I want one CSV/TXT file that should contain multiple tables data.

I read in the pixelperfect report documentation that it can generate one file from multiple charts/tables. I tried to find the documentation but I could not. Not sure whether the documentation is not right there or we're missing something?

Re: How to Create Text file from multiple straight tables in NPrinting

Daniel_Jenkins — Wed, 13 Jan 2016 22:39:39 GMT

Hi Zeeshan,

The QlikView NPrinting Training Material has an example. Check the report called PixelPerfect Report to CSV. This report exports multiple tables to a single CSV file. Add it to a task, set the Output Format to Csv and change the separator to '~' under the Advanced options. Run the task.

HTH - Daniel

Re: How to Create Text file from multiple straight tables in NPrinting

Anonymous — Thu, 14 Jan 2016 12:18:30 GMT

Daniel,

This is good information to know. I went and looked at the Excel output for a task and CSV is not even an export choice. Seem odd that you can export Pixel Perfect to CSV and not EXCEL. Did that get resolved in version 17 or am I missing something here?