DSE / Data Query / Join

'Join clause' examples

input.reference==rightInput.RefPiece3D

'Outout expression' examples

Example with 'if' statement

{part:input,
rm_name:input.rm_name=="Lithium Hydroxide"?"Lithium HO":input.rm_name=="Lithium carbonate"?"Lithium":input.libelle.toLowerCase().contains("tole rna")?"Aluminium LME":input.rm_name,
physical_id:rightInput.first.physical_id,
module:input.gf=="E4"?
"BATTERY":input.gf IN ["E1","E2","E3"]?
"ELECTRICAL ENGINE":input.gf.substring(beginIndex: 0, endIndex: 1) == "M"?
"ENGINE":input.gf.substring(beginIndex: 0, endIndex: 1) == "B"?
"GEARBOX":"BODY"
}