Manipulation of the field format in an excel document

I have an excel file. It is necessary that the column up to line 13 should be of string format, below line 13 it is necessary that it should be in the format of a numeric value. Tell me how you can implement this in KNIME

Hi @Nuke_Attokurov,

Why did you have to change the information below 13 line? It is the same kind? a number? or your file change all the data? Can you bring here a flow example?

Seeya,

Denis

I need to create a report like this. Everything that is colored green is a number format. Yellow is what is colored string format. You see, where green is painted, although it is a number higher, the same column is a string. How to implement this in KNIME, please tell me.

Can you attach a sample from these data that you have here, to reply with a possible solution?

I understand that the knime will bring only the table with number, double, string context with the excel writer node. the firsts lines until nr 10 will be just ignored and create a new one. You can put it at the same excel as a new tab spreadsheet or a new file, as you wish.

image.ocr.xlsx (11.8 KB)

From the file I want to get at the output. You see, I have a tabular structure. I want to add a template from above that is available here.

Hi @Nuke_Attokurov , knime won’t breing this result as you wish… you can insert with excel write note a table to a file direactly… the fields are the sabe type from the table.

You can use the renamer node some times for it as string manipulation multi columns node too… but you need to manipulate the information before the export process…

Seeya,

Denis

1 Like

Thank you very much.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.