Hi @TLKNW , I see that this is using the workflow from here:
The workflow I supplied for that question was this:
but (as noted in that original thread and the above image) this was based on the assumption that the upper Excel Reader was reading all the files from the folder without a header, and then a single read (without data rows) from the lower Excel Reader was used to pick up a “good” header, to be applied to the resultant output.
However, you now have this within a loop based on List Files/Folders, so firstly you wouldn’t want to put the single Excel “header” read within the loop, and secondly if you are looping through all files and reading all files on each loop iteration, then yes you would have duplicates.
So… do you need the loop? (I don’t see what purpose it serves), but if you do:
- What is the config now on the upper Excel Reader?
- The lower Excel Reader (plus all the associated "Column Header and Transpose nodes) want to occur after the loop