Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to Split a Duration Column into Separate Columns for Days, Hours and Minutes?

Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi Anonymous 
    I have taken your sample data for example. please the follwing steps in PQ:
    1) duplicate 2 time same column 

    2) make sure its is in duration data type all 3 columns

    3)right click on column> Tarnsform > day

     

    4) then you will get only Days. do the same for hour and mints.

       5) after doing for hour and minus you will get the desired result.

     

    I hope i answered your question.



Anonymous's avatar
Anonymous
Not applicable
2 years ago

.

AnthonyJoseph's avatar
AnthonyJoseph
Icon for Resolver III rankResolver III
2 years ago

Hi Anonymous, might be because of the column name. Can you try renaming the column name to be "Duration" i.e. removing space and special characters.