Hi @helalmob and welcome to the forum -
Here’s an example workflow to get you started. You’ll need to adapt this to include whatever cleanup on your data you want to do, and of course this isn’t a one size fits all solution - but maybe it will give you an idea of how you can use the DB nodes, along with flow variables to govern database table names.
I’m using an H2 Connector here, but of course you can swap this out for an Microsoft SQL Server Connector with appropriate credentials.
sas7bdatToDatabaseExample.knwf (27.1 KB)
I didn’t post this example to the Hub since it’s fairly specific to your problem, but please do check the KNIME Hub for other example workflows on working with DB nodes, loops, and flow variables.