Previously a value with a $, £ or € currency symbol (e.g. You can now output clickable hyperlinks to Excel format files.ĩ. You can use the Decode transform to escape special HTML characters in some columns.Ĩ. This allows you to write ‘raw’ HTML, for example to have hyperlinks in your HTML output. You now have the option not to escape special HTML characters (such as ‘’) when you output to HTML. If you wish to remove the hyperlink, to keep the old behavior, you can do this with a Replace transform.ħ. When hyperlinks are read in from Excel they are now input in the form anchor|hyperlink. The Edit button in the Right pane now opens files with UNC paths, e.g. Clicking this button will display the folder that the current file is being input from or output to. There is now an Open folder button in the Right pane for input and output items. For example you will get a warning if the file extensions is. There is now a message in the Right pane Warnings tab if the extension of an input or output file does not match the file Type supplied. In the Join, Lookup, Intersect and Subtract transforms you can now click on the Explore Keys… button to examine how key columns compare in the two input datasets.ģ. Confirm files is always off if you are running Easy Data Transform from the command line interface.Ģ.The format of the files output is set by Type, regardless of the file extension.file names with illegal characters) are ignored. If the folder a file is to be output to does not already exist, the file will not be output. Easy Data transform will not create new folders.You can use either / or \ characters as folder delimiters on Windows or Mac.This column is not output.Ĭheck Confirm files if you want to be prompted before writing files.Įach row will then be written to the file location in the Files column column. Set the Files column to the column containing the file locations. Select an output item in the Center pane and set Output to to Multiple files in the Right pane. If you are outputting to Excel you can also include the sheet name: The file location can be an absolute path, e.g.: If there isn’t such a column already, you should be able to create it using transforms such as Row Num, Concat Cols and Substitute. Make sure a column in your dataset has the location of the file you want each row to be output to. This can be useful when splitting a large dataset by row type or into multiple smaller files. You can now dynamically output rows of one dataset to multiple files, with the file locations set by a column in the dataset. You can uninstall old releases after you have successfully installed this version. Please let us know of any problems or issues you encounter with the release. We recommend that you back-up important transform files before installing any new release. The download links are at the bottom of the page. This release adds improvements and bug fixes to v1.23.1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |