Forum Discussion
How to Split a Duration Column into Separate Columns for Days, Hours and Minutes?
- 2 years ago
Hi Anonymous
I have taken your sample data for example. please the follwing steps in PQ:
1) duplicate 2 time same column2) 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.
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.
- Anonymous2 years agoNot applicable
.