Pick up Dates from initial rows as a column

Question

Hi All,I have got data in below shape:-&nbsp;Data is ImportantData is&nbsp; blah blahData is since 01/01/2019&nbsp;&nbsp;&nbsp;Column1Column2Column3poaa22lkbb3&nbsp;I want to do below 2 things:-a. Avoid first 4 rows since they are not part of data, just an information.b. Still use date in 3rd row-01/01/2019 as 4th column. So that it can b used in Reporting.&nbsp;Can this be done.&nbsp;Regards,RDS&nbsp;&nbsp;&nbsp;

zubair_muhammad · Accepted Answer

rds_2019&nbsp;
&nbsp;
Hi,
Please see if this useful. File attached as well
&nbsp;
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckksSVTILFbwzC3ILypJzCtR0lECoVgduNyhBQpJOYkZYAJTVqE4My85VcHAUB+IjAwMLZGUIDGd83NKc/MMgVwIywjOMgbLF+QDBRITgYSREVggJxvITkoCEkAFsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
    #"Removed Top Rows" = Table.Skip(#"Changed Type",4),
    #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
    #"Added Custom" = Table.AddColumn(#"Promoted Headers", "Date", each Text.AfterDelimiter(#"Changed Type"{2}[Column1], " ", {0, RelativePosition.FromEnd}))
in
    #"Added Custom"

Forum Discussion

Pick up Dates from initial rows as a column

1 Reply

Related content

SQL initialization error

Find Most Recent Date Relative to another Date Column in Power Query

Progressive Date Columns

Extract initials from names column

Initial Publishing Date

Data is Important
Data is blah blah
Data is since 01/01/2019

Column1	Column2	Column3
po	aa	22
lk	bb	3