Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Dublin, IRL

Welcome to the Dublin User Group

Click in the JOIN GROUP button in Home to follow our news and attend our events!

Weekly exercise #7

Carlos_A
8 - Asteroid

Hello all,

 

Sorry for the delay in posting this week's exercises, from now on I will, be posting these on fridays. You can also find the solution to last week's exercise here. For this week we'll be looking at formatting data to a given output:

 

Use Case: A credit card company’s customer Data is structured so that each row of data contains the merchants each customer has visited in a given week. The credit card company is wanting to understand the correlation of merchants visited by customer, for example if a customer visit 7-11 what other stores do they have a high propensity to visit.

 

Objective:  Restructure the data into rows that pair merchants together by customer.

2 REPLIES 2
Carlos_A
8 - Asteroid

Hi everyone,

 

I have attached my solution and the one provided by Alteryx to this week's exercise.

giuseppe
8 - Asteroid

Hi Carlos, attached my solution