Connect customers time series

[loman]

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 🙂

[Clément_Stenac]

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]

Thank you very much Clement. I'll try it :). Now i'm gonna try to group by customer Id in my output table.

[loman]

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 ^^