Forum Discussion
We cannot apply operator & to types Text and Table.
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:
4 Replies
jgeddesSuper User
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.
Thank you. Am I not allowed to put this step within the same table? It gives me an error.
- Ahmedx
try to do this and then in other requests you can refer to this request
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.
