July 19, 2023
The excel file is too large to upload and I can't figure out a way to make it small enough to keep the Power Query Active.
I have a power query in excel that pulls the information from an Access Database. It is currently only pulling the information from Access when the discrepancy type fields are filled out in the Database. I would like the Query to pull the information from the database as soon as the NCMR number field is filled out.
I did not set up these Power Queries and have very little experience with Power Queries. The person who set this up is no longer with the company.
Below are the current parameters set up.
Source: = #"NCMR Main Table-Access_Import_Headers"
Appended Query: = Table.Combine({Source, #"NCMR Main Table-Access_Import_Type1", #"NCMR Main Table-Access_Import_Type2", #"NCMR Main Table-Access_Import_Type3", #"NCMR Main Table-Access_Import_Type4", #"NCMR Main Table-Access_Import_Type5"})
Promoted Headers: = Table.PromoteHeaders(#"Appended Query", [PromoteAllScalars=true])
Changed Type: = Table.TransformColumnTypes(#"Promoted Headers",{{"NCMR Number", type text}, {"Date", type date}, {"NCMR Type", type text}, {"Part Number", type text}, {"Lot Quantity", Int64.Type}, {"Number Rejected", Int64.Type}, {"Discrepancy Type", type text}, {"Discrepancy", type text}, {"Discrepancy Qty", type text}, {"Disposition", type text}, {"Cause", type text}, {"Machine Number", type text}, {"Oper1", type text}, {"Oper2", type text}, {"Oper3", type text}, {"Oper4", type text}, {"FORMAL CAR REQUIRED?", type logical}, {"Q-220 Analysis Req?", type logical}, {"Closed?", type logical}})
Filtered Rows: = Table.SelectRows(#"Changed Type", each [Discrepancy Type] <> null and [Discrepancy Type] <> "")
There are 7 other imports with the one above. The above is the Main one that lists the Table of information from Access.
Moderators
January 31, 2022
Trusted Members
October 17, 2018
1 Guest(s)