Hi, i am new to KNIME. My requirement is to consolidate multiple csv files and upload the data to mysql database. i am able to consolidate using the below workflow.
I have 1 challenge here. Excel has 1048576 rows only, but i have data more than 11lakh. Therefore i have split the multiple file into 2 groups and consolidating. It worked fine, but i have challenge updating the consolidated 2 excel file to db.
Could some one help what is the optimized way of consolidating these file and upload to db?