Formating Issue

[ravi13]

Hello Knime Experts!!

Hope you are doing well.

I am facing formating issue in knime, i just want your guidance for creating formating as shown below:

which node shall i use ?

Thanks in advance.

[izaychik63]

I do not see issue here. You can do sophisticated formatting in KNIME reporter BIRT. If you need to return formatted data to Excel try Continental nodes.

XLS Conditional Formatter — NodePit

so on.

[ravi13]

Thanks @izaychik63
but whether using above mention node can we mention sr.no., scop from AABK, material no ,material group, net value – under Details of Dr./Cr. Notes (Data from AABK) & same for all other column under Details of Dr./Cr. Notes (Data from VBBK)…
my issue is not putting color, but is to bifurgate two column, and get sub-column underneath it .

I hope understand my concern…

[izaychik63]

See here how to duplicate columns. Take in account that KNIME does not work with merged columns.

Duplicate column

Hi there, I need to duplicate a column ( new column has the same values). e.g. Col Duplicated Col 1 1 2 2 1 1 4 4 10 10 etc. I can’t find a duplicate column node. Any suggestions? Thanks in advance.