Forum Discussion

romoguy15's avatar
romoguy15
Helper IV
4 years ago
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...
Need Help
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    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/

Anonymous's avatar
Anonymous
Not applicable
4 years ago

or

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Zc67DcAgDIThVZBrhMzZkMRdBkBKj9h/jTwc0qT99J90vVOuCQkIq2ELR6NIeXHJbLqGvdGInSCOxQpuiwR1WUzxVUmeJYzZK3FRkzqj7RdlfsmEZ3X9+mWT2KD31zFO", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [wodcr = _t, wodco = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"wodcr", type datetime }, {"wodco", type datetime}}),
    ttc=Table.TransformColumns(#"Changed Type",{{"wodcr", each DateTime.Date(_), type date},{"wodco", each DateTime.Date(_), type date}})
in
    ttc