Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 s...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please try

    Classify 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] )
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 
Please try

Classify 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] )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Ahhh that's awesome! Thank you!