ER - Copy all the TI variables
Is your feature request related to a problem? Please describe.
In many times we receive files with really bad formatting, the file may have 100~300 columns, we need to do trimming the data so that it avoid unnecessary issues when loading the data into TM1.
Recently TM1 is pretty unpredictable when it takes space as nothing or a space as space, so right now we always need to trim the data properly in the TI, but when we are having 1020 files to load, each files with similar scale (100300 columns of data needed to trim), this is rather painful for a developer.
Describe the solution you'd like
A way to copy all the variables. Maybe a snippet function to take all the string variable and insert trim TI statement in Metadata/Data tab.
Describe alternatives you've considered
No alternative I can think of, right now doing it manually, really painful and not efficient.