Connect customers time series

loman
loman Registered Posts: 4 ✭✭✭✭

Hello,

I'm searching a solution to connect the customer activity table to my customer profil table.

I tried the function join and group without success. DSS created new row in my customer profile table

If someone has a tip to connect my timeseries I'm interested :)

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    Hi,

    You're definitely looking for the "Join" recipe.

    * Add first your "time series" dataset
    * Then add your "profile" dataset
    * Select customer id as the join key
    * In the columns selection, select all columns from the time series table and the additional columns that you want from the profile

    Assuming that there are no duplicates in your "profile", a regular ("inner") join will work.

    The output will contain one record per record in the "time series" dataset, with added customer profile info.

    Hope this helps,
  • loman
    loman Registered Posts: 4 ✭✭✭✭
    Thank you very much Clement. I'll try it :). Now i'm gonna try to group by customer Id in my output table.
  • loman
    loman Registered Posts: 4 ✭✭✭✭
    Well, don't work, i think i need to transpose from a Multiple-Rows-per-Subject(customer id) Data Set to a One-Row-per-Subject(customer id) Data Set. I need to invest in a ETL ^^
Setup Info
    Tags
      Help me…