Forum Discussion

Mooihoek's avatar
Mooihoek
Helper II
5 years ago
Solved

Spilt Column and create New Row

I'm trying to spilt the U from this column and then have that value as a new Column called Test which then have that value and on the same row as the other values, e.g in green. .  Any ideas on how t...
Need Help
  • Mooihoek's avatar
    Mooihoek
    5 years ago

    thats it I now have the data load the way I need, your awesome! v-yalanwu-msft 

mussaenda's avatar
mussaenda
Community Champion
5 years ago

Hi Mooihoek ,

 
 
 
 
 

try this on a blank query

 

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUtJRUorViVYyNDSxNDUE8ozM9Q1M9I0MjAzB4qFgBbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Case Number" = _t, #"Date Submitted" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Case Number", type text}, {"Date Submitted", type date}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each #"Changed Type"{2}[Case Number]),
    #"Filtered Rows" = Table.SelectRows(#"Added Custom", each [Date Submitted] <> null and [Date Submitted] <> "")
in
    #"Filtered Rows"

 

 

 

Hope this helps

Mooihoek's avatar
Mooihoek
Helper II
5 years ago

This is where I'm at, Created two new columns Type &Time however those values need to come up a row.

 

 

Because there's an error there on the top row it won't let me complete a Fill Up then filter the columns, any thoughts?