There are various ways to exclude columns in your data in Dataverse. This article provides some examples. THIS ARTICLE IS ONLY RELEVANT IF YOU ARE USING BRAINSCRIPT. In Dataverse we recommend using the new Transform node which supports Python. See this article for an example of how to use the new Transform node and the Transform node section of the online documentation for further details.
You can use the exclude statement with the emit output statement to list the fields that you want to exclude from the output.
For example, to include all fields from an incoming data set except for the field named 'color':
Alternatively, you can simply list the fields that you want to include with the emit output statement.
For example, to include only the fields named 'color' and 'id' and ignoring all other fields from the incoming data set:
emit 'color', 'id'
You can use the emit and exclude statements above along with the wildcard statement, which matches column names to a simple pattern.
For example, to include all fields that contain "id" somewhere in the name:
emit wildcard "*id*"
For small examples of the above, save the attached .lna file and import into your instance of Dataverse.