Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
Date transposing changing the format
Process_Intern
Hi all,
My question seems to be simple but I cannot find the answer. I have some data with a date format that I need. My dates are at the columns level for the moment. For a reason, I need to transpose the table that I have. My date now becomes Row. My problem is that when I am transposing, the date format change and I don't know how to bring it back to the original format. I will post two screenshots below for a clearer image. For the moment, in the first picture, I am looking to transpose Row #1 into second screenshot Row #2 and #3. My date format as gone from regular to ten digits date that I cannot transform. Could somebody help me?
Thank you
Find more posts tagged with
AI Studio
Developer
Accepted answers
hbajpai
Hey
@Process_Intern
In this case RapidMiner is converting your date time to UNIX timestamp. You can try to convert from date to nominal (for eg: "yyyy-MM-dd HH:mm:ss") before transpose, that would preserve the data structure for you.
All comments
hbajpai
Hey
@Process_Intern
In this case RapidMiner is converting your date time to UNIX timestamp. You can try to convert from date to nominal (for eg: "yyyy-MM-dd HH:mm:ss") before transpose, that would preserve the data structure for you.
Process_Intern
It worked, thank you Harshit!!
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups