Hello,
I have an extracted report from PowerBi. What I want is whenever I drop it in this specific folder it will generate multiple sheets (a summary of tables I need to see). I have already set it up but my problem is when I open a file from the folder it did create the 3 table summary in separate sheets but the results is multiplied as to how many files is in the folder
[quote=“bws, post:1, topic:91108”]
Can you explain what this means?
“but the results is multiplied as to how many files is in the folder”
Hello,
When the folder contains only 1 file, the results are accurate but when the folder contains many files, the results are bigger than its supposed to be
The structure of your workflow is totally unclear. Can you share the workflow?
@bws welcome to the KNIME forum. Mostly in this cases you will have to plan ahead and decide at every steps what should happen. I try to build something using loops - or if necessary nested loops. You can access every element of an Excel file like sheet names and then aggregate the results as you wish. You can extract names and use them later as (again) sheet names or file names. Just as you wish. Sometimes it might make sense to handle the first iteration differently (create an initial file that then will be populated).
This and more you can read about here:
Maybe as @rfeigel has suggested you can tell us more about your case or even share a workflow.