https://community.qlik.com/t5/Talend-Studio/ignore-new-columns-while-loading-into-postgressql/m-p/2330995#M100022 <P>I've done this before using <A href="https://help.talend.com/reader/9NRa~CylzTWZ8bFvUjlang/yJ3uVEzDciOxdy9B9G1tBw" alt="https://help.talend.com/reader/9NRa~CylzTWZ8bFvUjlang/yJ3uVEzDciOxdy9B9G1tBw" target="_blank">dynamic schema</A>. Basically you query the target metadata to get a set of columns, and the incoming file to get a set of columns and do a set difference to get the new columns from the source, from there you can use the common columns to load to tgt.</P><P>&nbsp;</P><P>You may also be able to use POSTGRES' ON CONFLICT IGNORE functionality, but I've never tested this use case</P> Wed, 10 Mar 2021 17:45:04 GMT evansdar 2021-03-10T17:45:04Z https://community.qlik.com/t5/Talend-Studio/ignore-new-columns-while-loading-into-postgressql/m-p/2330994#M100021 <P>I am trying load data from a csv file to postgres table using dynamic load.</P><P>I am trying to see is there an option to ignore new columns added in the source file while loading into postgressql</P> Sat, 16 Nov 2024 00:27:52 GMT https://community.qlik.com/t5/Talend-Studio/ignore-new-columns-while-loading-into-postgressql/m-p/2330994#M100021 ekamal 2024-11-16T00:27:52Z https://community.qlik.com/t5/Talend-Studio/ignore-new-columns-while-loading-into-postgressql/m-p/2330995#M100022 <P>I've done this before using <A href="https://help.talend.com/reader/9NRa~CylzTWZ8bFvUjlang/yJ3uVEzDciOxdy9B9G1tBw" alt="https://help.talend.com/reader/9NRa~CylzTWZ8bFvUjlang/yJ3uVEzDciOxdy9B9G1tBw" target="_blank">dynamic schema</A>. Basically you query the target metadata to get a set of columns, and the incoming file to get a set of columns and do a set difference to get the new columns from the source, from there you can use the common columns to load to tgt.</P><P>&nbsp;</P><P>You may also be able to use POSTGRES' ON CONFLICT IGNORE functionality, but I've never tested this use case</P> Wed, 10 Mar 2021 17:45:04 GMT https://community.qlik.com/t5/Talend-Studio/ignore-new-columns-while-loading-into-postgressql/m-p/2330995#M100022 evansdar 2021-03-10T17:45:04Z