Hello all, I have a table in Excel file and I would like to convert it to a specific .txt file. [image] I assume I’d need some kind of loop to achieve this. Is it possible to do such things in Knime? Thank you! Please see the attachments: SourceFile.xlsx (8.3 KB) output.txt (180 Bytes)

Hi @Stanislaw , I have taken some ideas from @mlauber71 ’s flow and put the attached flow together for your example. In this case, it increases the number of nodes used, but removes the loops. You have a number of specific challenges here. Firstly, your data is in “matrix format” and this ideally needs to be converted into tabular format so that it can then be processed. This can be done by the Unpivot node (Step 1 in my workflow). Secondly (Step 2), now with the data in tabular form, ItemCode - Date - Value, and sorted on ItemCode/Date you need to process it and determine the required outputs. (In my workflow, I converted you date strings to actual date/time columns for the purposes of sorting. I think your dates are already in sortable order, so this is actually unnecessary in this instance. However, if you ever supplied dates in a different string format then this step would probably be required.) You are requiring different outputs depending on if this is the first row for an ItemCode, the final row, or one of the rows in between. Effectively its like having a “head”, “body” and “tail”. You therefore need to know where you are within the processing for each line. For this you can Rank the rows, and determine how many there are for each ItemCode. After that, a Column Expressions node can create the required output per row (encoding line separators - I used pipe | characters - within the output as required). Third (Step 3), having generated your “pseudo” output, you need to turn this into a data set of individual rows for each line to be output. You can do this with a Cell Splitter and Unpivoting which generates new rows based on the divided cell contents. Finally (Step 4) is any tidy up required and then writing to the output using CSV Writer. In my workflow I have written to Output.csv using CSV Writer, and Output2.csv using CSV Writer (deprecated) nodes. I was unsuccessful in making the “current” version of CSV Writer output blank lines. If anybody knows a trick for that it would be useful! [image] KNIME_Excel to TXT.knwf (223.9 KB)

Converting XLSX to specific TXT

KNIME Analytics Platform

mlauber71 April 28, 2021, 7:55am 2

Maybe you could take a look at this example and adapt it for your needs:

3 Likes