Metabase 'Field to map to' Variables while using joins

Get Help
1

I have a query that joins two tables :
select CAST(pvt.Year AS VARCHAR) as Year, pvt.Description as 'Description', [6],[1],
from (
select fre.*,ec.Description from stat.Table1 fre
left join stat.Table2 ec on ec.Code = fre.Table2Code
where Year = {{Year}} [[AND Variable = {{Variable}}]][[AND {{Description}}]]
) sr
PIVOT
(
Max(Weighted_Avg) FOR [Variable] IN ([6],[1],)
) pvt
order by pvt.Year

I want a variable with 'Field to map to' but when i try to do so it gives this error :

The multi-part identifier "stat.Table2.Description" could not be bound.

example

2

Hi @enisnovus
You cannot use table aliases for the Field Filters that you’re referencing via the side panel.
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type
https://github.com/metabase/metabase/issues/3324 - upvote by clicking :+1: on the first post

3

Thank You i fixed the problem from advises in this thread https://github.com/metabase/metabase/issues/3324