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
jisaenz's avatar
jisaenz
Helper I
2 years ago

I created the week custum coulmn to allow me to filter the files for the previous 90 days and is working form here I would like to add the week as coulmn to the transform file. Them in the transform file I would like to clean the data in the first file, change the types and Unpivot some coulms previous to combine them