Write expression for conditional check

[Sahil]

Hi,
I want to write this code in expression snaplogic.
I need to map TestID.

<xsl:variable name=“TestID”>
<xsl:if test=“exists(node()/IDOC/A1[VW=‘F’]/NO)”>
<xsl:copy-of select=“node()/IDOC/A1[VW=‘F’]/NO”>
</xsl:copy-of>
</xsl:if>
<xsl:if test=“not(exists(node()/IDOC/A1[VW=‘F’]/NO))”>
<xsl:copy-of select=“node()/IDOC/A1[VW=‘F’]/NP”>
</xsl:copy-of>
</xsl:if>
</xsl:variable>

How do I do it?

[Sahil]

“copy-of” will copy the value of the xml element.

[viktor_n]

You can try something like this.

$Data.IDOC.A1.get('@VW') == "F" ? $Data.IDOC.A1['@VW'].get('NO', $Data.IDOC.B1['@VW'].NP) : null

If this won’t work then, you can send me sample data so I can have better understanding of the problem.

[Sahil]

hi, it did not work.
below is the xml:-

<?xml version="1.0" encoding="UTF-8"?>
<Data>
	<IDOC BEGIN="1">
		<K01 SEGMENT="1">
			<CURCY>EUR</CURCY>
			<RECIPNT_NO>4455566</RECIPNT_NO>
		</K01>
		<ED SEGMENT="1">
			<QUALF>014</QUALF>
			<ORGID>A</ORGID>
		</ED>
		<ED SEGMENT="1">
			<QUALF>009</QUALF>
			<ORGID>002</ORGID>
		</ED>
		<A1 SEGMENT="1">
			<VW>ZB</VW>
			<NP>WEE</NP>
			<NO>55666</NO>
		</A1>
		<A1 SEGMENT="1">
			<VW>GS</VW>
			<NP>0000070252</NP>
			<NO>334455</NO>
		</A1>
		<A1 SEGMENT="1">
			<VW>LF</VW>
			<NP>0000070252</NP>
			<RAS>E</RAS>
			<NO>23334455</NO>
			
		</A1>
		<A1 SEGMENT="1">
			<VW>LS</VW>
			<NP>0000070252</NP>
			<NO>55666</NO>
		</A1>
	</IDOC>
</Data>

so in the above example, it should give 23334455 and if <NO> does not exists then 0000070252.

[pmanchevski]

Hello @Sahil

Did you try to use it XLST transformer snap? It transforms your incoming data by applying the XSL transformation rules.

You don’t need to map it by hand.

Regards,
Pero Manchevski

[Sahil]

Hi,
I am working on a migration project and migrate from SAP platform to snapLogic.
so it would be better if I do it in expression inside mapper.