Alteryx Designer Desktop Discussions

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

missing date details required

Kapil_Lambhate
5 - Atom

Hi,

 

i have dates in my column "H" and Column "I" represents the number of months missing, so how can i get the output like

 

Pricedate+2= Aug, Sep and soo on. 

 

Date_format.pngDate_format.png

1 REPLY 1
Prometheus
12 - Quasar

@Kapil_Lambhate I used the Generate Rows tool to create a record until RowCount <= Missing Month Price. Then I used the Formula tool to calculate the missing months and format that into abbreviated month names. Lastly, I used a Summarize tool to group by PRICEDATE and Missing Month Price then concatenate the month names with a comma delimiter.

GR Missing Months.PNG

Find Month Names.PNG

Concat Missing Months.PNG

Labels