@BackupArian I think KNIME should be able to handle your task although it will most likely involve several steps and data preparations. You have asked several question in the forum that seem to have something to do with this…
Your task will involve many steps from different domains of KNIME like similarity of strings, loops and so on.
From my experience it will be best if you could construct a maybe collection of sample files that represent the whole of your challenges (with dummy data so as to not spell any secrets). Then the community will be able to solve the problem and you can then use that in your real world task.
Of course you can try to put it together bit by bit but that can be frustrating for all participants - more often than not after one problem has been solved another complication comes along: oh well my column names are not the same, oh and I would want this for several years.
If the whole of the task would be in the sample file it will be easier to think about all the possible implications. And often during creating a sample representing you task you might be forced to structure what you expect KNIME to do.