Forum Discussion
How combine multiple files from folder NO table
and after it should be like this :
Do not forget that the most left is 0, then 1. So you might have to change the number if your data are not on the most left sheet of your files.
You might have to add a step to promote headers but not always the case. Just check if your headers are in place otherwise add a step after Navigate to promote headers.
Tell us if it works...
First, you need to select the query on the left, exactly as you did.
Then select the step Navigate on the right (Applied steps)
You should see in the formula bar (your picture) the old formula with the sheet name.
Once you've located this line you do the replacement in formula bar, in fact you need to modify the existing line, not to create a new one.
Tell us if it works...
With a picture might be easier 😉
and after it should be like this :
Do not forget that the most left is 0, then 1. So you might have to change the number if your data are not on the most left sheet of your files.
You might have to add a step to promote headers but not always the case. Just check if your headers are in place otherwise add a step after Navigate to promote headers.
Tell us if it works...