What is the difference between Table[Column] and Table.[Column]?

Hello,

Is there a difference between Table[Column] and Table.[Column] when trying to reference values from other tables?

If so, how do you use each case.

Is one a column list expression and the other is not? (See snipped from Appsheet documentation below)?

  • from-dataset-column : The specification of the table or slice (the โ€œdata setโ€) to search and the column from which values are to be gathered, in the form: dataset-name [column-name] . For example, Orders[Order ID] . Although identical in appearance to a column list expression, this argument is not an expression.
0 3 154
3 REPLIES 3
Top Labels in this Space