I have a multi sheet Workbook which I’m collating to one dataset for import to a larger database. I can bring in the multiple sheets as individual files which is great (a shift select would make selecting the sheets I want much easier though).
The issue I have is that I cannot copy settings from one file read input to another. I need to ignore the first 11 rows of each input file which I have to do individually on 40 or so files.
Also when I create a single tree there is no way to copy those transforms to multiple file inputs which would be the other way to solve this. It seems the node tree view is not powerful enough.
Anonymous - So my workbook comes in like this and I stack the separate sheets and perform some other transforms on the data. Problem is each of the file inputs need to have the same settings. They need to ignore the first 11 rows of the input sheet and ignore empty columns.
Admin - It would be great to have an option where you can perform the same operation on multiple nodes at the same time as you mention. The duplicate function needs to stay copied to the same tree or it will lose it’s settings.
The shift select would be useful in the dialogue box used to select the sheeets to import. It’s just a tickbox list which is tedious to tick when you have 30 or 40 to do!
I have a problem to get the point, too. But if you want to join multiple files with identical input, have you tried to use the batch processing. Configure one file with the parameter “ignore first 11 rows” and output the data into file with mode append.
I do such stuff even in terminal scripts, where I delete the old output file before execute the next process cycle in the script.
The Choose Excel sheets dialog has ‘check all’ and ‘uncheck all’ buttons. Selecting is different to checking, so I’m not sure shift select would be useful, unless you also had ‘check selected’ and ‘uncheck selected’ buttons.
Open up your transform file in any text editor and change the ignored_rows values from 0 to 11 or whatever you need and same goes for to ignore empty columns, change ignore_empty_cols values from 0 to 1 and save it and when you open up in EDT, all is set as you wanted in one go.
@Admin already mentioned how to select all 40 or whatever number all at once, by clicking on the button select all instead of clicking one by one.