There's a way to select all the json?

[Igor_do_palido_ponto]

Supose that I want to take all number 1 in my table and delete isso, despise the column. How can I target it via json?

[MutedJam]

Hi @Igor_do_palido_ponto, I am not quite sure I understand what you have in mind here.

Are you looking to delete all items with a value of 1 in any field? So in a dataset like below, you’d like to delete the top and bottom item, but keep the middle one?

I don’t think there’s a simple way to achieve this without Code. With a bit of JS it should, however, be relatively simple. Here’s an example:

Result:

Hope this helps!

[Igor_do_palido_ponto]

Imagine that I have a table with 4 columns and 4 rows:

a-b-c-d
1 - 2 - 2 - 1
2 - 2 - 1 - 1
1 -1 -1 - 1
2 - 2- 1 - 2

I want to target the entire json and replace all 1 numbers. There’s a way to do it?

[Jon]

Hey @Igor_do_palido_ponto,

Did the example not help? It looks like it close to what to what you are after although I don’t know what you want to replace the number with but it should work as a starting point.