Forum Discussion
bug in lookupvalue
HI Expert,
there is bug in lookup value it does filter the data between centrlize fact table for an example
table1 deptid,deptname
table2 empid
Table3empid,deptid
i wanted fetch the data in table1 and table2 but lookupvalue showng blank value
lookupvalue(table1.deptname,table1.empid,table2.deptid) ... we can not use table3 as it is used in switch function
7 Replies
Shreesefwere , Create two-column and then try to merge , you will not be able use three tables
you can Try a new column like
New column in table 2
Dept Name=
var _tab = filter(Table2, Table3[empid] = table2[empid])
return
maxx(filter(Table1, Table1[deptid] in _tab), Table1[deptname] )
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8can you explaint this query
Dept Name=
var _tab = filter(Table2, Table3[empid] = table2[empid])
return
maxx(filter(Table1, Table1[deptid] in _tab), Table1[deptname] )------this section
suggestion please
can you please explain what is happening in the query
Dept Name=
var _tab = filter(Table2, Table3[empid] = table2[empid])
return
maxx(filter(Table1, Table1[deptid] in _tab), Table1[deptname] )------this section
suggestion please
suggestion please
