Forum Discussion

Stever25's avatar
Stever25
Frequent Visitor
5 years ago

Search in Lookuptable and return value

Hello,

 

I search a solution since weeks for the following problem. 

We have millions of products with a productdescription from several producers. In every description is exactly one part of text which describe a feature of the product. This feature we like to analyse. For this we build a powerfull lookuptable. In one column is the part of the text we expect in the description, in the second table we have the feature we like to analyse.

Has anyone an idea for a measure? There is no relation between the tables.

I like to solve it with a measure. I have a poor solution with a calculate column but with very poor perfomance.

 

Thx

 

lookup

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Stever25 

    Do you want to show the code you currently have for the column? It will help understand the requirement. Best if you can share some sample data as well, in text-tabular format

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers