2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

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

Generate Further Months in Same Row

harshal98
8 - Asteroid

Want to Generate Further Months in the Same row while it takes other Column values with it where values are present.

 

INPUT

harshal98_0-1622522348374.png

OUTPUT

harshal98_1-1622522373305.png

 

 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @harshal98 

 

Your understanding is correct if we use generate rows it will replicate the row values. To avoid that months should be generated separately and later joined with values.

atcodedog05_0-1622526413003.png

 

Hope this helps 🙂

 

Qiu
19 - Altair
19 - Altair

@harshal98 
We can fine tune the dateformat.

Capture3A.PNG

AngelosPachis
16 - Nebula

Hey @harshal98 ,

 

The TS filler tool would work best in this instance

 

AngelosPachis_0-1622528033723.png

 

You just need to point it to the Date field and define the date granularity (days, months, minutes) and it will generate the intermediate values.

 

Hope that helps

 

Cheers,

 

Angelos

 

Jonathan-Sherman
15 - Aurora
15 - Aurora

Love this solution @AngelosPachis, the TS Filler tool is so underrated and overlooked for this kind of thing! It is worth noting that anyone wanting to take this approach does need the predictive tools installed 😊

atcodedog05
22 - Nova
22 - Nova

Always something new to learn. Thank you for this approach @AngelosPachis 🙂

Labels