Skip to main content
W
wfalco16-Pearl
16-Pearl
October 22, 2019
Solved

Relation to omit parameter in BOM

  • October 22, 2019
  • 1 reply
  • 2678 views

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

Best answer by MartinHanak

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

 

1 reply

M
MartinHanak24-Ruby IIIAnswer
24-Ruby III
October 23, 2019

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

 

    W
    wfalco16-PearlAuthor
    16-Pearl
    October 23, 2019

    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

    W
    wfalco16-PearlAuthor
    16-Pearl
    October 23, 2019

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

    Terms & ConditionsCookie settingsAccessibility statement