Create table with datatypes from source but ONLY selected columns
I noticed the functionality to create a second output on SELECT from database and connect that to the second input on INSERT so that the destination table can be automatically created with the correct data types.
Unfortunately I only want to select and insert a small number of columns from the original table, not all of them. Instead of creating a table with only the columns I’m selecting it is creating a table with all the same columns as the source table.
I managed to prevent this by putting in a mapper which sets the column names to null to exclude those columns, however I need to do this based on the columns which were actually selected by the SELECT rather than hard-coding it into a mapper.
What’s the best solution for this please?
Many thanks,
Chris