How do I combine columns from my reference data to the transactional data I'm working with?

AMuresan
AMuresan
in Data preparation

I have some sales but want to attach more details about the products to the dataset before using it in a model.

Comments

  • Bhuvan
    Bhuvan

    In order to combine columns between multiple data sets, you may use the Join Tool

    Here's an example demonstrating an inner-join on sales and product data:

    Products Table: This table contains sample product data

    Screen Shot 2023-03-24 at 3.13.54 PM.png

    Order Table: This table contains sample sales data

    Screen Shot 2023-03-24 at 3.14.55 PM.png

    We can configure a Join Tool like so:

    Screen Shot 2023-03-24 at 3.15.25 PM.png

    The different types of joins that are currently supported by Symon.AI are Left Join, Right Join, Inner Join, Left Anti Join and Full Outer Join

    We can also add more join conditions as desired

Categories