cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Relation to omit parameter in BOM

SOLVED
Highlighted
Alexandrite

Relation to omit parameter in BOM

Hi all,

 

Could have searched this. But in somewhat of a hurry to get this done.

 

I am looking to blank certain cells in my bom that have the parameter "material" in the repeat region.

 

How do I write the relation?

 

Thanks,

 

WayneF

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Relation to omit parameter in BOM

Hi,

what parameter is placed in the "material" column ? Suppose it is &asm.mbr.compmat

 

1.] repeat region relations

IF asm_mbr_compmat=="2"

compmat2=""

ELSE

compmat2=asm_mbr_compmat

ENDIF

 

2.] when relations are created then replace &asm.mbr.compmat with &rpt.rel.compmat2 in "material" column

 


Martin Hanák

View solution in original post

5 REPLIES 5

Re: Relation to omit parameter in BOM

Hi,

what parameter is placed in the "material" column ? Suppose it is &asm.mbr.compmat

 

1.] repeat region relations

IF asm_mbr_compmat=="2"

compmat2=""

ELSE

compmat2=asm_mbr_compmat

ENDIF

 

2.] when relations are created then replace &asm.mbr.compmat with &rpt.rel.compmat2 in "material" column

 


Martin Hanák

View solution in original post

Re: Relation to omit parameter in BOM

Martin,

 

My parameter is "material".

 

I tried both:

 

IF asm_mbr_material=="2"
material=""
ELSE
material=asm_mbr_material

ENDIF

 

&

 

IF asm_mbr_material=="2"
material2=""
ELSE
material2=asm_mbr_material

ENDIF

 

Neither work. I am most likely misunderstanding.

The first one makes sense. The second one adding "material2" does not make sense.

Oddly enough both are accepted. However the "2" remails in the matrail column.

 

Wayne

Re: Relation to omit parameter in BOM

My bad!!! I never changed for step 2. Awesome. Works! Thanks Martin!

Re: Relation to omit parameter in BOM

Hi,

I think you understand that I do not have enough time to guess what's wrong on your side.

Please prepare test-data (drawing, assembly, parts) and upload them. I will check repeat region then.

I responded too soon.


Martin Hanák

Re: Relation to omit parameter in BOM

No big. so did I. Thanks again. I knew it was something this simple.

Announcements
LiveWorx Call For Papers Happening Now!