Hello all, I did use Generate Rows before and it worked just fine, this time I am having this issue and not sure how to fix it.. here is my example: I want to have another Row for 2017:06:22 17:00:21.. Not sure why it is not doing it.. this is how my Generate Rows tool properties look like: I appreciate your thoughts on this.. Rawan

Generate Rows issue..

Hello all,

I did use Generate Rows before and it worked just fine, this time I am having this issue and not sure how to fix it.. here is my example:

Alteryx Designer x64 - GNAV.yxmd__2018-05-15_11-54-33.png

I want to have another Row for 2017:06:22 17:00:21.. Not sure why it is not doing it.. this is how my Generate Rows tool properties look like:

Alteryx Designer x64 - GNAV.yxmd__2018-05-15_12-00-01.png

I appreciate your thoughts on this..

Rawan

This might work for you (it will work, but is it what you want?) and is worth a try:

Change your initialization to find the hour that the min starts:

datetimetrim([min],"Hours")

Cheers,

Mark

This might work for you (it will work, but is it what you want?) and is worth a try:

Change your initialization to find the hour that the min starts:

datetimetrim([min],"Hours")

Cheers,

Mark

Thanks so much for suggesting this, it does work for our reporting purposes. I really appreciate your help..

Rawan