Forum Discussion
Lookup value using table variable. Cannot find table variable
Hi
I am trying to simplify my dashboard modeling by using a table variable instead of creating an actual table and lookupvalue from there. The problem is when I try to lookupvalue from table it says it is expecting a basetable instead. here is the code
I am trying to simplify my dashboard modeling by using a table variable instead of creating an actual table and lookupvalue from there. The problem is when I try to lookupvalue from table it says it is expecting a basetable instead. here is the code
Classify by Customer SalesDocType =
VAR
_table_var = GROUPBY(customer_mapping_tbl, customer_mapping_tbl[SoldToParty], customer_mapping_tbl[SalesDocType], customer_mapping_tbl[Order Acquisition Classification])
_table_var = GROUPBY(customer_mapping_tbl, customer_mapping_tbl[SoldToParty], customer_mapping_tbl[SalesDocType], customer_mapping_tbl[Order Acquisition Classification])
RETURN
LOOKUPVALUE(_table_var[Order Acquisition Classification], _table_var[SoldToParty], sales_document_header_data_tbl[SoldToParty], _table_var[SalesDocType], sales_document_header_data_tbl[SalesDocType])
Hi Anonymous
Please tryClassify by Customer SalesDocType = VAR T1 = GROUPBY ( customer_mapping_tbl, customer_mapping_tbl[SoldToParty], customer_mapping_tbl[SalesDocType], customer_mapping_tbl[Order Acquisition Classification] ) VAR T2 = FILTER ( T1, customer_mapping_tbl[SoldToParty] = sales_document_header_data_tbl[SoldToParty] && customer_mapping_tbl[SalesDocType] = sales_document_header_data_tbl[SalesDocType] ) RETURN MAXX ( T2, customer_mapping_tbl[Order Acquisition Classification] )
2 Replies
Hi Anonymous
Please tryClassify by Customer SalesDocType = VAR T1 = GROUPBY ( customer_mapping_tbl, customer_mapping_tbl[SoldToParty], customer_mapping_tbl[SalesDocType], customer_mapping_tbl[Order Acquisition Classification] ) VAR T2 = FILTER ( T1, customer_mapping_tbl[SoldToParty] = sales_document_header_data_tbl[SoldToParty] && customer_mapping_tbl[SalesDocType] = sales_document_header_data_tbl[SalesDocType] ) RETURN MAXX ( T2, customer_mapping_tbl[Order Acquisition Classification] )