Skip to main content
A few days ago I posted a support ticket for the "DateDiff" function within a transformation as it was not allowing me to select "Weeks" from my units of measure and ONLY Days. While the documentation online states there should be many selections for this function (Days, weeks, months, etc), it was not appearing and there are time-sensitive deliverables for me (Admin) that required this information to be calculated properly.





Not only did we derive a solution, but I also was able to learn a valuable thing about GS that perhaps I missed or overlooked in training, and here it is:





You can perform and data transformation on an existing data transformation! (cue heavenly choral singing!)





So since we were able to only derive Days from the function, GS Support created a second transformation that converted the initial one to weeks by dividing the previously established DAYS by 7.





HUGE KUDOS AND SHOUT OUT TO @ankur_bhat you provided excellent support and rocked this issue!!!! And BIG THANKS to all support members involved and their rapid attention, responsiveness and creativity!!!!



@keith_mattes Thanks for letting us know! and great to hear that you learnt new things.





If you get a chance please share is the learnings, will be helpful for others too.





@ankur_bhat Good job!




Yes the primary item that was learned was the ability to perform a transformation on an existing transformation. For some reason I thought it was limited!




Reply