Selection don't affect all the tables

[#1]

Hello

I want two create two tables with same fields but with different value of one field

table1: filed1, field2, field3 (make a selection for particular value)

table2: filed1, field2, field3 (make another selection different from table1)

I want that the selection maked in table1 do not affect the table2

[alexandros17]

Use alternate state, define it in Setting -> Document properties then use in the objects (do not forget to use them even in filters)

[avinashelite]

Use QUALIFY *; in the start of the table i.e after the connection statement, it will make your tables uniqe.

[lironbaram]

hi you can use alternate state

which create different set of the data that a not connected

you define the alternate states in the doc properties ,when clicking on the alternate state button

then when creating the table you can assign each table to different alternate state