2 Replies Latest reply: Jun 26, 2017 10:39 AM by Eric Hannert RSS

    count amount of nr by match between two columns in two tabels

    Eric Hannert

      Hi comm,

       

      I have the following problem.

      I want to count the article_nr of table1 by a type_string from table2 that is a part of an element_string from table.

      I think I need count, wildmatch and aggr or set analysis.

      I tried a lot but I couldn't find the right formular.

       

      so for example i have

      in table 1

      nr    element_string  .... 

      1     11(2)230          .....   

      2     11(2)230           ......

      3     12(2)330          .....

      4     11(2)230           ....

      5     09(4)234              .....

       

      in table i want to show

      type_string     amount

      230               3

      330               1

      234               1

       

      hopefully I have explained it in a way u guys understand it.

      Thx for an answer.