Forum Discussion
Reference a value in a table to use in another SQL power Query
Double quote missing before the closing square bracket I think.
I notice you're missing a table alias for your SHIP_DATE_RETURN, not sure if that will cause you any abiguity issues.
This is just the query portion, make sure it goes inside the correct ().
[Query=" SELECT rd.SERIAL_NUMBER , rd.REF_NUM , rd.MODEL_ASC , pm.MODEL , rd.MOTO_PART_NUMBER , rd.ASC_SITE_ID , ras.ASC_SITE_NAME , rd.REPAIR_TYPE , acm.ASC_CUSTOMER_NAME , rd.WARR_CODE , rd.RMA_CREATION_DATE , rd.EXPIRY_DATE , rd.RECV_DATE , rd.SHIP_DATE_RETURN , rd.UNIT_STATUS , rd.PROJECT_NAME , rd.FINAL_UNIT_DETERMINATION , rd.INVOICE_NUMBER , rd.INVOICE_DATE , ROUND((SHIP_DATE_RETURN - rd.RECV_DATE)) AS AGE , (rd.RECV_DATE + 30) AS TAT , rd.LABCOST , rd.FREIGHT_COST FROM rdwadmin.rdw_repair_details rd , rdwadmin.rdw_part_master pm , rdwadmin.rdw_asc_customer_master acm , rdwadmin.rdw_asc_site ras WHERE rd.moto_part_number = pm.moto_part_number AND rd.ASC_CUSTOMER_NUMBER = acm.ASC_CUSTOMER_NUMBER AND rd.ASC_SITE_ID = ras.ASC_SITE_ID AND rd.INVOICE_NUMBER = '"& #"Current-Invoice"[CurrentInvoice]{0} &"' "]
From memory, the syntax for the value in SQL is '" &Value& "'.
Depending on your exact scenario, you may want to drill down on that single value table to make it easier to reference, e.g. right click on the single value and choose 'drill down'.
Once you've drilled down, say the query of single value is called myValue.
I think what you're looking for is something like...
SELECT x, y, z FROM myTable WHERE myColumn = '" &myValue& "'
Hope this helps.
KNP and if OP wants to pass on directly a query to SQL
let
Source = Sql.Database("serverName", "dbName", [Query="select * from tbl where WO='"&Table[C1]{0}&"'"])
in
Source
Table is following
Hi smpa01
Apologies, i only just read your reply. I have tried to pass to the SQL query and did have a couple of issues with PQ not liking the code, but it seems to have accepted an edited version.
However it does not bring any data back.
Really appreciate your support 🙂