I am trying to customize my workflow so that I read in an Input File with over 1000 columns and then read in an Excel File with those columns I want to work with (Column File). I then concatenate the two so that the output table only has those columns I wish to work with (single row with the column names)
==> This is what I came up with as a simple way to feed my columns into the workflow so that I don’t have to chose them every time (by using the Column Filter Node)
Challenge is that when the concatenation is complete, all the column types have changed to ?.
I want to maintain the column types from the Input File so am looking for some guidance on how to maintain this?
- One idea I had was that I would specify values in the Excel file as a second row so that upon reading in (via the Excel Reader node) that the column types would be what I wish them to be.