Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a csv file such as:
Header1, header2, header3
A, b, c
D, e, f
Report generated on 19/05/2024
I'd like to transform to
Date, Header1, header2, header3
19/05/2024,a,b,c
19/05/2024,d,e,f
Can some one help me with the table.split m function or suggest something else?
Thanks
Solved! Go to Solution.
hello, @RamblingFire something else:
let
Source = Csv.Document(File.Contents("full_path_to_your_file"),[Delimiter=",", Columns=3, Encoding=1252, QuoteStyle=QuoteStyle.None]),
prom = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
dt = Date.FromText(
Text.AfterDelimiter(Table.Last(prom)[Header1], "Report generated on "),
[Format = "dd/MM/yyyy"]
),
z = Table.AddColumn(Table.RemoveLastN(prom, 1), "Date", each dt)
in
z
hello, @RamblingFire something else:
let
Source = Csv.Document(File.Contents("full_path_to_your_file"),[Delimiter=",", Columns=3, Encoding=1252, QuoteStyle=QuoteStyle.None]),
prom = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
dt = Date.FromText(
Text.AfterDelimiter(Table.Last(prom)[Header1], "Report generated on "),
[Format = "dd/MM/yyyy"]
),
z = Table.AddColumn(Table.RemoveLastN(prom, 1), "Date", each dt)
in
z
Thank you so much!