0 Replies Latest reply: Nov 24, 2017 4:11 AM by Christian Lauer RSS

    Join Table and count

    Christian Lauer

      HI,

       

      lets say i have two tables and i wanna join them on a certain attribute. Table A is the important one with something like NR,price,name,etc. Now I want to join Table B with NR,Name,type,etc. on the attribute NR. The questions I have are:

       

      -Is it possible to do such things via Data manager (Drag and Drop) or only in script mode?

      -Is there such a thing like join on?

      - What is the most easy way to get from table A NR,Price,Name and only count (NR) from table B? So i wanna see how often NR from table A is part of table B...

       

       

      Thanks!