Right now, you can use case formula for String, Number, and Boolean but it would be great to allow Date.
For example, I did a comparison between two date by subtracting them from each other to compare to columns of dates to determine which was the later date. In the next transform, I was to do a case where if DIFF is POSITIVE then select DATE 1 otherwise select DATE 2. This will allow me to do a comparison between two columns of dates
I would argue this enhancement is still needed.
If we had it, the solution would be one task with a case statement. What I proposed with the union will require an additional 3 unions/tasksminimum.
+2I just ran into this need the other day. My workaround was to convert dates to strings in one transformation, then do a case statement in a second transformation, and then parse back into a date in the a third transformation. Not pretty.
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
