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

SOLVED
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

Tags (3)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

## 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
5 REPLIES 5
Highlighted

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

## 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
{"extraction_info": {"found_math": false, "script_math_tex": 0, "script_math_asciimath": 0, "math_annotations": 0, "math_alttext": 0, "mathml": 0, "mathjax_tag": 0, "mathjax_inline_tex": 0, "mathjax_display_tex": 0, "mathjax_asciimath": 0, "img_math": 0, "codecogs_latex": 0, "wp_latex": 0, "mimetex.cgi": 0, "/images/math/codecogs": 0, "mathtex.cgi": 0, "katex": 0, "math-container": 0, "wp-katex-eq": 0, "align": 0, "equation": 0, "x-ck12": 0, "texerror": 0, "math_score": 0.9558082222938538, "perplexity": 13102.959802940333}, "config": {"markdown_headings": true, "markdown_code": true, "boilerplate_config": {"ratio_threshold": 0.3, "absolute_threshold": 20, "end_threshold": 15, "enable": true}, "remove_buttons": true, "remove_image_figures": true, "remove_link_clusters": true, "table_config": {"min_rows": 2, "min_cols": 3, "format": "plain"}, "remove_chinese": true, "remove_edit_buttons": true, "extract_latex": true}, "warc_path": "s3://commoncrawl/crawl-data/CC-MAIN-2020-05/segments/1579251705142.94/warc/CC-MAIN-20200127174507-20200127204507-00514.warc.gz"}