Moving data in rows to different column

[lazaronewhall17]

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

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.

[HansS]

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

[lazaronewhall17]

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