Hi Guys,
Was wondering using clearcollect how do you add columns as well as rename a existing column in the one line of code.
Example: collection A has a column called results. I want to rename results to "type" and add in another column called "style".
This line of code will run a few times as uses can update its row values, so i need a if statement that if the columns already exist not to add or renanme.
Any help is greatly appreciated.
Thanks
Example:
AddColumns(RenameColumns(myCollection, "results", "type"), "style", "some style")
Hope this helps,
RT