Forum Discussion
Data View column order change
I created this Idea - Aug 24, 2015
Still waiting...:smileysad:
CahabaData Sean Alirezam CodySydney
Use the function 'SELECTCOLUMNS' to create a copy of the original table and reorder the columns in it.
This is how you use it:
SELECTCOLUMNS(<OriginalTableName>, "<Column1NewName>", <Column1OriginalName>, "<Column2NewName>", <Column2OriginalName> ............)
No answer yet to a function which should be easily solved by developers. The possibility of rearranging columns in the dataview helps tremendously in the development of solutions!!!
Your "this is how you use it" explanation is too brief. I presume, though you don't say that this is a non-destructive technique. Is it? Also, after it has been used what do you have? Do you have a new table containing all the columns and formulae that were in the original, that's what I'd want, or a table with the results of any formulae/calculations/lookups in the orginal table but, now, no formulae? Do you now have two tables where there was one? Do you then delete the original? Hide the original? You beg a lot of questions. Also, where does one enter this code? In the PQ layer?
