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

    Use connected data


      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