Forum Discussion
Reuse steps applied in a excel file
- 9 years ago
I've found my problem yesterday yet. My destination column had a wrong name.
Thanks everyone!
Since the Advanced Editor includes the filename, you can't copy/paste the full field.
1. Find the point in your first table where you started doing your own edits - usually after the table.transformColumnTypes section.
2. Copy everything AFTER that.
3. Add your new table.
4. find the line that also has the table.transformcolumnTypes for that table. The line after that is probably the "in" line.
5. Add a comma at the end of that Table.Transform line as there probably isn't one.
6. Delete the lines after that.
7. Paste what you copied from your original report into this new table advanced editor box.
8. Check if any errors. Click OK if none.
This is what I found to be what works. But - this is assuming that the replacing values will be the same each month.
I've found my problem yesterday yet. My destination column had a wrong name.
Thanks everyone!