1 Reply Latest reply on Nov 21, 2018 2:45 AM by daniel.andell

    Use connected data

    daniel.andell

      I have connected (Blending) two data files with. One includes all sales per product and the second one includes only Product numbers on new products.

       

      What I would like to do is to use the second file as a filter. So I can automatically look at only products that is is in the second file.

       

      I thought this was possible with an IF statement like

      IF Product = file2(Product) THEN Product

      And then use this calculation to bring in date or any other things.

       

      Hope there is a way to solve my question

      Thanks