Ignore Transformation

The Ignore transformation makes the column invisible in the table. The column is still part of the prepared source, but it is not displayed.

When you select a column and click Ignore, the screen refreshes and the column is gone. To get it back, click on the Ignore icon in the pipeline and select delete.

FAQ: What is the difference between using Ignore in the Prepare page and just excluding it when you define the connection in the Connect page?

If you do not need a column anywhere in your dashboard or reports, then do not put it in the connection. It then is not extracted from the original source. Sometimes you need a column in some reports and not others. In this case, extract it and use it in a prepared source for a report that needs it. Then, use the Ignore transform in the prepared source for a report that does not need the column.