Remove/Filter out some columns possible?

[G0nz0uk]

Hello,

I have to import a huge CSV that a system dumps out that we can't change, but I only need maybe 10 columns from it.

Is there a way I can just show these and not the whole CSV?

Thanks

[marcusolsson]

Yes! The caveat is that you need to define a schema with the 10 columns you want to keep. Once you've done that, click Ignore unknown, and any fields that's not defined in the schema will be removed.

[G0nz0uk]

Hi Marcus, so that is done in the panel itself and not the data source?

[G0nz0uk]

Is this where I do it?

[marcusolsson]

1. In the query editor, add the fields that you want to include, and optionally their types
2. Enable Ignore unknown to hide any field you have included

[G0nz0uk]

Amazing, thanks works perfectly.

One last question, can I rename a column name, for example if it's pulled in from the CSV as 'Country' can this be renamed as something else or does the CSV need to be edited? Problem we have a 3rd party system exports the csv so we can't easily change it on the source end.

[marcusolsson]

Definitely! You can rename (and reorder) fields from any data source using the Organize fields transform.

[G0nz0uk]

Amazing! Thanks.