Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Generate rows from data range

Dan-Ketil
5 - Atom

Hi

 

I am a newbie in Alteryx

I have a table looking like

Customeriddatestartdatestop
12021-01-01 
22020-01-012023-12-31
32020-06-012021-06-30
42021-02-012024-12-31

 

Now I need to two things.

1: where ever datestop is not se, I will sett it to end of current year + 5. So for customerid 1 datestop be set to 2026-12-31, that I know how to do

2: i need to create a table looking like

Customeridperiod
12021-01
12021-02
12021-03
1

2021-..

1

2021-12

1

2022-01

1

2022-....

 

How do I solve this?

 

BR

Dan

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

@Dan-Ketil ,

 

 in short, I'd use this CReW macro:

 

https://gallery.alteryx.com/#!app/Generate-Date-Rows/5e31f42a826fd30ffcbf2c14  

 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Dan-Ketil
5 - Atom

Thanks Mark

 

Beeing a newbe this seems abit heavy to understand at first glance, but I will look further into your suggestion.

 

BR

Dan

echuong1
Alteryx Alumni (Retired)

You can use the generate rows to create records for the values in between. See attached.

 

I split everything out so it's a little easier to understand, but you can definitely consolidate some things.

 

echuong1_0-1618578610078.png

 

Labels
Top Solution Authors