If you have 26 fields A-Z and you want to select all the fields except column D you can do so with the following syntax: Select *, ~D.
This is much easier than typing Select A, B, C, E... Z
This is most useful when you want to modify a field with a C9 function. Lets say you want to use the IfNull function on column D to replace all the null values with N/A.
Instead of typing all 26 fields out you can do: Select *, ~D, IfNull(D, N/A) as D
You can use this to omit multiple fields as long as the fields start with ~ and are comma separated.
The only thing to watch out for is that your new D column will now be your last column but if the order matters you can always rearrange the order in the final step or at the widget level.
Please sign in to leave a comment.