Moving data in rows to different column

Good afternoon,

I have a text file that I’m converting using two spaces a a delimiter value since I couldn’t find a best way to split the data in the File Reader node. Suggestions are welcome :slight_smile:

After that I’m using a Column aggregator and then a cell splitter to get the result I desire. The challenge I’m facing is that the outcome has certain rows moved to the left since Column B is coming in as blank. See Below:

The desired outcome would be moving the cells to the right in order to match the rest of the column. Getting a blank in column only happen to dept number 20010 which is the last column in the highlighted rows in the picture above.

Here is the workflow used:


PSF PSI.knwf (14.4 KB)

Also the data source:

Data File.txt (14.4 KB)

Thanks in advance for the support.

1 Like

Hi @lazaronewhall17

You can apply your workflow to your dataset without the first 2 columns. In this example
PSF PSI v2.knwf (20.3 KB) the first to columns are set aside, and in after aggregating and splitting the columns are combined together again.

gr. Hans


Why you make this look so easy :slight_smile: Thank so much as always for the great support HansS

1 Like

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