loading data into new table by if expression

[Woojtek_96]

Hi all,

I have two tables and want to load into a new (probably temptable?) table my statements results.

For example

If("cell in columnA"="cell in ColumnB";true;false') and those true and false i want to put into a this new third table and make some operations like count or sum, on them.

thanks for help, if I'm unclear with my question tell me, and i will try to explain it better

[arpitkharkia]

Using a sample app to explain your problem will help

[Woojtek_96]

thank you!