combine 2 text files

KNIME Analytics Platform
1

I have the problem and trying to look for answers
I have 2 Files : File A and File B
I have to concat the 2 files in such a wat that File B data is appended to the bottom of File A --Concat node does this job, all good

The challenge is, the first file has a trailer record which looks like this
TRAIL|"50

It starts with TRAIL and has row count for File A

When I append File B to File A, this trail record should be the last record in the concatenated file with the record count being updated

File A : 50 records
File B : 60 records

The record should be as:
TRAIL|"110

2

Hi @chaithuj , you could first use a row splitter on both files to split off the final row from each.

Process those two records to aggregate the record count from each

Then concat the other rows from A to the other rows from B and the newly calculated summary row.

2 Likes
3

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