2Table name having the same column name

[naveenkumardnk2]

2Table name having the same column name. we using the select query Without thisrow why will take the all values. 

SELECT(Block[Cluster Name],[Block name]= [Block Name

For me Select query without Thisrow Table name is the same, column name is also the same name. I want the right answer.

[TeeSee1]

Suppose you have two tables A and Block.

Also suppose you write a virtual column in table A.

1) SELECT(Block[Cluster Name], [Block Name] = [_THISROW].[Block Name])

So this expression returns a list (a SELECT expression returns a list) per row in table A.

The list contains the Cluster Names of all the rows in table Block whose [Block Name] matches the [Block Name] of each of the rows of table A.

2) SELECT(Block[Cluster Name], [Block Name] = [Block Name])

This also returns a list per row in table A.

However without [_THISROW], any [bracket column] is regarded as a column in table Block (this is specified as the first part of the first parameter in the SELECT statement). So [Block Name] = [Block Name] will ALWAYS evaluate to be TRUE because you are comparing the [Block Name] of each row of table Block against itself, therefore all the rows' [Cluster Name] are returned for all of the virtual column in table A.

It is clearly stated in the help document.

https://support.google.com/appsheet/answer/10108207?hl=en