@lgarduno I think it should be possible to do that. We had a somewhat similar discussion here:
It all depends on how ‘regular’ your structure is and how many variations there are. You could modify the above approach or import the whole dataset into a KNIME table and deal with the data later.
The best thing would be you could create a sample file that best represents you whole set of challenges (without giving away any confidential data).