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 need it to have unique keys in the transfor filw if not the combine will be genrating duplicates the unique key that I want is Week, Site, Part, Period. Site Part Period exists in the excel files.