Notes
Notes - notes.io |
Source = Excel.Workbook(Parameter1, null, true),
#"Order_detailing Source" = Source,
Order_Detailing_Sheet = #"Order_detailing Source"{[Item="Order_Detailing",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Order_Detailing_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Sales Order Number", Int64.Type}, {"Purchase Order", type any}, {"Jobber #", Int64.Type}, {"Order Type", type text}, {"Detailing Skill", type text}, {"Started By", type text}, {"Start Time", type datetime}, {"Completed By", type text}, {"End Time", type datetime}, {"Status", type text}}),
#"Removed Blank Rows" = Table.SelectRows(#"Changed Type", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
#"Inserted Literal" = Table.AddColumn(#"Removed Blank Rows", "Literal", each "OD", type text),
#"Renamed Columns" = Table.RenameColumns(#"Inserted Literal",{{"Literal", "Type"}}),
#"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns",{"Type", "Sales Order Number", "Purchase Order", "Jobber #", "Order Type", "Detailing Skill", "Started By", "Start Time", "Completed By", "End Time", "Status"}),
#"Filtered Rows1" = Table.SelectRows(#"Reordered Columns", each ([Status] = "Detailed")),
#"Filtered Rows2" = Table.SelectRows(#"Filtered Rows1", each not Text.Contains([Completed By], "Other User")),
#"--OD--" = #"Filtered Rows2",
#"Order_entry Source" = #"Order_detailing Source",
Order_Entry_Sheet = #"Order_entry Source"{[Item="Order_Entry",Kind="Sheet"]}[Data],
#"Promoted Headers1" = Table.PromoteHeaders(Order_Entry_Sheet, [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers1",{{"Sales Order Number", Int64.Type}, {"Purchase Order", type any}, {"Jobber #", Int64.Type}, {"Order Type", type text}, {"Detailing Skill", type text}, {"Entry Skill", type text}, {"Started By", type text}, {"Start Time", type datetime}, {"Completed By", type text}, {"End Time", type datetime}, {"Status", type text}, {"Detailed By", type text}}),
#"Removed Blank Rows1" = Table.SelectRows(#"Changed Type1", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
#"Added Conditional Column" = Table.AddColumn(#"Removed Blank Rows1", "Custom", each if [Sales Order Number] = 10471664 then "OE" else "OE", type text),
#"Renamed Columns1" = Table.RenameColumns(#"Added Conditional Column",{{"Custom", "Type"}}),
#"Reordered Columns1" = Table.ReorderColumns(#"Renamed Columns1",{"Type", "Sales Order Number", "Purchase Order", "Jobber #", "Order Type", "Detailing Skill", "Entry Skill", "Started By", "Start Time", "Completed By", "End Time", "Status", "Detailed By"}),
#"Removed Columns" = Table.RemoveColumns(#"Reordered Columns1",{"Entry Skill", "Detailed By"}),
#"Filtered Rows3" = Table.SelectRows(#"Removed Columns", each ([Completed By] <> "Other User")),
#"--OE--" = #"Filtered Rows3",
#"Appended Query" = Table.Combine({#"--OD--", #"--OE--"})
in
#"Appended Query"
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
