Create a new table through selection

[#1]

Hi,

I would like to create one new table through my selection, its possible?

For example, i have one selection per year, i´d like clicking in button and create a table only with registers of my selection.

Table1:

cod, year

1, 2012

2, 2012

3, 2013

4, 2014

5, 2015

Selection:

2012

Click on button and create a new table...

NewTable:

cod,year

1,2012

2,2012

Thanks,

Robson Henrique

[#2]

save 2012 (selection) to variable

add partial reload as a trigger on button

in the script use variable to load only 2012 to new table

[#3]

in my case i have many selections, how do it?

Thanks...

[Gysbert_Wassenaar · Accepted solution]

Here's an example. If you have more selections, just add variables for each field and expand the where clause with the other selections:  ...where match(Field1, $(var1)) and match(Field2, $(var2)) and ... etc.