Forum Discussion
Solved
Adding A custom Column to the Transform file
I am working in Data Factory with Power Query using a Folder Connector I Created a Custom Coulmn extracting information form the Name of the file and I would like to be included in the Trasnform file...
Use this:
letSource = Folder.Files("C:\Users\jisae\OneDrive\Documents\jj-Analytics\Data"),#"Added custom" = Table.TransformColumnTypes(Table.AddColumn(Source, "Week", each Text.Middle([Name], 12, 10)), {{"Week", type date}}),#"Filtered Rows" = Table.SelectRows(#"Added custom", each Date.IsInPreviousNDays([Week], 90)),Custom = Table.TransformColumns(#"Filtered Rows", {{"Content", each Excel.Workbook(_, true), type table}})inCustom
Provide whole query please.
let
Source = Folder.Files("C:\Users\jisae\OneDrive\Documents\jj-Analytics\Data"),
#"Added custom" = Table.TransformColumnTypes(Table.AddColumn(Source, "Week", each Text.Middle([Name], 12, 10)), {{"Week", type date}}),
#"Filtered rows" = Table.SelectRows(#"Added custom", each Date.IsInPreviousNDays([Week], 90)),
Custom = Table.TransformColumns(#"Filtered Rows", {{"Content", each Excel.Workbook(_, true), type table}})
in
Custom
Use this:
letSource = Folder.Files("C:\Users\jisae\OneDrive\Documents\jj-Analytics\Data"),#"Added custom" = Table.TransformColumnTypes(Table.AddColumn(Source, "Week", each Text.Middle([Name], 12, 10)), {{"Week", type date}}),#"Filtered Rows" = Table.SelectRows(#"Added custom", each Date.IsInPreviousNDays([Week], 90)),Custom = Table.TransformColumns(#"Filtered Rows", {{"Content", each Excel.Workbook(_, true), type table}})inCustomFinally I found to add the week column to the data table not the Transform but works
Table.SelectColumns(#"Removed columns 1", {"Week", "Transform file"}) only addig Week.