https://community.qlik.com/t5/Talend-Studio/Loading-200-Files-to-200-Snowflake-tables/m-p/2329926#M99065 <P>Hi , I have a problem in which i want to load 200+ files into 200+snowflake tables (upsert logic) , Earlier for 50 around tables i had used 50 different filelist and 50 fileinputdelimited components . Are there any inbuilt components to handle this or a mechanism which could be used to implement this . I don't want to use filelist and fileinputdelimited for every new File which we get.</P><P>Some of the files coming have similar names to differentiate them i have used regex.</P><P>Is there a possibility to create a hashmap and use that in the single component to load all the files to respective tables and implement upsert logic.</P> Fri, 15 Nov 2024 22:25:21 GMT Rishab1 2024-11-15T22:25:21Z https://community.qlik.com/t5/Talend-Studio/Loading-200-Files-to-200-Snowflake-tables/m-p/2329926#M99065 <P>Hi , I have a problem in which i want to load 200+ files into 200+snowflake tables (upsert logic) , Earlier for 50 around tables i had used 50 different filelist and 50 fileinputdelimited components . Are there any inbuilt components to handle this or a mechanism which could be used to implement this . I don't want to use filelist and fileinputdelimited for every new File which we get.</P><P>Some of the files coming have similar names to differentiate them i have used regex.</P><P>Is there a possibility to create a hashmap and use that in the single component to load all the files to respective tables and implement upsert logic.</P> Fri, 15 Nov 2024 22:25:21 GMT https://community.qlik.com/t5/Talend-Studio/Loading-200-Files-to-200-Snowflake-tables/m-p/2329926#M99065 Rishab1 2024-11-15T22:25:21Z https://community.qlik.com/t5/Talend-Studio/Loading-200-Files-to-200-Snowflake-tables/m-p/2329927#M99066 <P>Hi </P><P>To iterate multiple files in the specified directory, tFIleList is the right component to do it. If some files are not updated, use the tFilelist to iterate all files and then select only the new files and process these new files? </P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Fri, 28 Oct 2022 05:01:46 GMT https://community.qlik.com/t5/Talend-Studio/Loading-200-Files-to-200-Snowflake-tables/m-p/2329927#M99066 Anonymous 2022-10-28T05:01:46Z