Forum Discussion
Solved
Split multiple columns in one step
Hello, I have two date and time colums that I am needing to split by delimiter and I want to split all two of these columns into one step instead of having to do it in individual steps. I tried a cou...
Hi romoguy15 ,
If your columns are already of the type datetime, then you could use this statement:
= Table.TransformColumns(#"Changed Type",{{"Work Order Date Created", DateTime.Date, type date}, {"Work Order Date Completed", DateTime.Date, type date}})In advanced editor it would look like this:
#"Extracted Date" = Table.TransformColumns(#"Changed Type",{{"Start date time", DateTime.Date, type date}, {"End date time", DateTime.Date, type date}}),Let me know if this helps!
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
if this is not what you are looking for, explain the waiting table in detail with examples
if this is not what you are looking for, explain the waiting table in detail with examples
This one is also really helpful too and works. For example if I am not trying to split dates but something else, I always wanted to know how to split two columns in one step