Table modification

[Yves57]

Hello

From an excell data source, I create a Sheet1 table. I want to duplicate this table to generate another one and by supressing for example the value 00000000000 in the field Material_1 how can I do this?

thanks for your help

[MFelix · Accepted solution]

Hi @Yves57 ,

Just duplicate the query and then add a filter on the Material_1 field that will remove the values you don't want to see.

If you want to always have the same treatment on both table for the future you should do a reference and not duplicate.