In many cases I really don't need to do anything that warrants opening Excel, but I do need the columns to be aligned so that it's easily human-readable (which Excel does excellently and N doesn't appear to handle at all). I put together an example and attached it here.I use Notepad to do a huge chunk of my day to day work, and one thing I have to deal with frequently is reading data from CSVs. Merge the two collections that were originally split, back into one. Add column(s) to the collection that contains the first set of columnsģ. There may be a slightly easier solution here, especially if you know the exact columns and are only looking to add one or two columns.Ģ.
This is not the most beautiful solution either but was easier for me to implement than the XML solution provided by you. This implies my process now has to read the XL and copy the contents to a collection, something that could have been avoided. I employed Excel's many features to get the collection as I want it to be.
Thanks for the swift reply! And thanks for the links, I now support both! If it doesn't paste back in, then you've made a mistake when changing the XML. You'll quickly see how to manipulate the XML and then just copy/paste back into the diagram. Hi Paul - it's default behaviour unfortunately but you can add your support to the enhancement requests others have made:Īs a workaround, and I admit this is very ugly, copy the collection and paste into a text editor that can format XML, eg Notepad++. This collection is not derived from an Excel so editing an Excel to solve this issue is not an option. How can I, when adding a new column to an existing collection, ensure it will stay where I defined it? Obviously, I could create a new collection with the same fields but now directly in the correct order, and throw away the 'faulty' one but this seems like the last resort workaround to me. Unfortunately, the collection definition panel does not come with 'Move up' and 'Move down' buttons as for instance the MultiCalc panel does. Whatever I do to keep it in position, BP moves it back again. However, after saving my work and opening it again, BP seems to be under the impression that newly added columns should be at the end of all columns and has moved it there. This new column is located somewhere in the middle of the collection as it belongs to a a group of fields located there. I added a column (Field) to an existing collection in my process.
0 kommentar(er)
