Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Macro to Join First Match

kheuer
8 - Asteroid

Hi community,

 

I have two datasets, one with customer numbers and the dates they were invoiced, and a second one that shows me the household numbers for the customers. Each customer can belong to multiple households. I want to iterate through the list of invoice dates and join the first household number of the second dataset to the first. Attached is a simplistic sample data set to explain what I am looking for. 

 

Thanks in advance.

2 REPLIES 2
Tyro_abc
11 - Bolide

Hi @kheuer 

 

Are you okay if this can be done without Macro? Is there any specific reason why you want to use macro here?

 

arundhuti726_0-1613622291718.png

 

kheuer
8 - Asteroid

Good point @Tyro_abc. I was overthinking this solution. Your idea is solving my problem. Thanks! 

Labels
Top Solution Authors