Forum Discussion

jisaenz's avatar
jisaenz
Helper I
2 years ago
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...
Need Help
  • dufoq3's avatar
    dufoq3
    2 years ago

    Use this:

     

    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
dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi, why do you need it in Transform File? You have filename in main query by default.