Forum Discussion
LOOKUP does not work
I have a huge main table called 'DVENDAS'; I have a new table using SUMMARIZECOLUMNS, that I called 'FS.0'; so I have a second new table using SUMMARIZECOLUMNS and FILTER again, that I called...
Hi Anonymous,
It could work on my side, could you please share some sample file to have a tets if possible?
Regards,
Daniel He
Yeah, I know! There is a table in same workspace called 'PTA' that I use LOOKUPVALUE in this way and it is working fine.
But in this specific case is not... Maybe because I am using with a summarized table? There is some specific event like that wich may cause this? I don't know.
I am not able to share my workspace because it is huge insane! 'DVENDAS' has more than 8 millions of rows, 'FS.0' +65.000 and 'FS.2' +37.000.
Do you know an alternative way to reach this result like LOOKUPVALUE? Like FIRSTNONBLANK but with filter?
Or someone knows what could be wrong here?