We cannot apply operator & to types Text and Table.

[cramkumar86]

Hi, 

I am trying to reference a date returned by another query in the SQL's where clause. As you can see in the images attached. there is a table 'me_date' that contains only one column 'business_date' with a single value. When I try to pass this date to another query connecting to Impala, it gives me the below error. Could you please help?

Expression.Error: We cannot apply operator & to types Text and Table.

me_date:

[Ahmedx]

try to do this and then in other requests you can refer to this request

[cramkumar86]

Thank you Ahmed. This helped me convert the table to a single value. But I get different error now, while pasisng this value to another query.

I have tried using some of the conversion options listed here. But none of them helped.

Type conversion - PowerQuery M | Microsoft Learn

[jgeddes]

Based on your screenshot, me_date is still a table. If the date is the only value in the table you should be able to add a Table.FirstValue step to the end of the me_date query to return just the date.

[cramkumar86]

Thank you. Am I not allowed to put this step within the same table? It gives me an error.