Navisworks Data Tools - Link Multiple Sheet into one query

[F.Bitetto]

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

[mikhail_mushurovF63]

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";

[jungyi_wang]

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!

[mikhail_mushurovF63]

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...

[jungyi_wang]

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!

 

 

[mikhail_mushurovF63]

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 

[jungyi_wang]

Dear Sir,

Could be provide the SQL OR sample for S3D column with several values from Element tab!!

thank you!

[mikhail_mushurovF63]

Hello!

Sure, check together with the attached excel's sheet SYS1

SELECT * FROM [SYS1$] WHERE "S3D"=%prop("Element","GUID") OR "S3D"=%prop("Element","Name")