Hi, i'm trying to create one query in order to connect multiple excel sheets using only one link.
I have used UNION statement but without success.
SELECT * FROM [Sheet1$] WHERE "CONSTRUCTION PACKAGE" = %prop("ENGINEERING STATUS", "CONSTRUCTION PACKAGE") AND "TITLE NUMBER" = %prop("ENGINEERING STATUS", "TITLE NUMBER ") UNION SELECT * FROM [Sheet2$] WHERE "DRAW ID" = %prop("Element", "DRAW_ID") AND "TITLE NUMBER";
Any suggestions?
Thanks
Hello, try this one:
SELECT * FROM [Sheet1$] WHERE "CONSTRUCTION PACKAGE" = %prop("ENGINEERING STATUS", "CONSTRUCTION PACKAGE") AND "TITLE NUMBER" = %prop("ENGINEERING STATUS", "TITLE NUMBER ") ; NAVISWORKS_MAGIC_NEXT_SQL
SELECT * FROM [Sheet2$] WHERE "DRAW ID" = %prop("Element", "DRAW_ID") AND "TITLE NUMBER";
Hello Sir,
I am try to connect with excel file and use the SQL code as below.
SELECT * FROM [SYS-INFO$] WHERE "S3D"=%prop("Item","WBS") OR "S3D"=%prop("Item","Name")
I want to confirm the sheet name <SYS-INFO> and column A list <S3D>, if value same as <Item-WBS> or <Item-Name>, then could be link the external information and show the information at another tab. But I am not sure why the SQL cannot working; if not use the OR, the link will work!! I still need try to how to solve the question.
thank you!
Hello! Could you attach here or send me somehow your documents? because I did a quick testing and OR is working for me in the similar case...
Dear Sir,
thank your help, i provide my sample nwd and excel file for you confirm.
If only for DwfName or WBS ISO, it could be success, but always fail when use or!!
thank you!
Hello!
To my own regret such connection did not work for me either.
I just may guess that such behaviour is due to the similar internal names of parameters in DWF - SmartPlant3D tab, because OR works when you try match S3D column with several values from Element tab
For example parameters from the Element tab:
Maybe some NAVISWORKS gurus could help us with this one? @Lance.Coffey @lee.mullin
Dear Sir,
Could be provide the SQL OR sample for S3D column with several values from Element tab!!
thank you!
Hello!
Sure, check together with the attached excel's sheet SYS1
SELECT * FROM [SYS1$] WHERE "S3D"=%prop("Element","GUID") OR "S3D"=%prop("Element","Name")
Can't find what you're looking for? Ask the community or share your knowledge.