Create multiple columns from rows of data

[stanciuc]

Hello,

I have a table with 2 column Name and Status(can have x or -).
Printing the table as it is will print 2 columns on several pages. That is not the desiered output format.
I would like the fields to be printed horizontaly and not verticaly.

Example:

Name Status
A   X
B   X
C    -
D   X
F    -
E    -
M   -
N   X

Expected output:
A    X    B    X    C    -    D    X
F     -    E     -    M    -    N    X

I'm Using latest NPrinting version. Thank you.

[Ruggero_Piccoli · Accepted solution]

Hi,

Qlik NPrinting May 2021 SR1 is out of support, so schedule the upgrade to a supported version. In the text you stated that you are using latest that is May 2023 SR2. In this case please use the right label, thanks. 

Qlik NPrinting works by column: you place the tag of a table or tag of columns of a table and they are expanded vertically with the data. It is not possible to expand them horizontally. 

You could:

- If you are developing an Excel template, add the column tags in an hidden Excel sheet and use Excel features to create a visible sheet with the layout you want.  In this case you can use the Excel function =TRANSPOSE(XX:YY)

- create a table in the source app with that layout, refresh the connection cache and import that table

- import the source object in the Cells node then drag and drop each single cell in the final position. This is feasible only if the source object has a limited size because you have to manually manage all cells and it is positional so if you change the order in the source table you have to update the tags in the template according

- if you use VBA macros remember that related code is only copied to the generated reports but never executed

Best Regards,

Ruggero

[stanciuc]

Excel function =TRANSPOSE(XX:YY) works.

Thank you!