This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Write expression for conditional check

Go to solution
Sahil
Contributor

โ€Ž08-31-2021 05:03 AM

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?

0 Kudos
1 ACCEPTED SOLUTION

Go to solution
viktor_n
Contributor II

โ€Ž09-01-2021 01:22 AM

Hi @Sahil,

Here are two expressions, I was not sure because it is array does always will have only one VW that contains โ€˜Fโ€™ in the value.

First expression. Finds all NO or NP that contains โ€˜Fโ€™ in VW field.
$Data.IDOC.A1.filter(e => e.get('VW').contains('F')).map(x => x.get('NO') != null ? x.NO : x.NP)

But I think that the second expression is more correct. This expression finds the first one element in the array that contains โ€˜Fโ€™ in VW, and returns NO if exist or else NP.
$Data.IDOC.A1.find(e => e.get('VW').contains('F')).get('NO', $Data.IDOC.A1.find(e => e.get('VW').contains('F')).get('NP'))

By default this expression return null, and if you want something else you can add second parameter in the get method for default values.
Ex: .get('NP', "Default")

Regards,
Viktor

View solution in original post

10 REPLIES 10

Go to solution
Sahil
Contributor
In response to viktor_n

โ€Ž08-31-2021 07:42 AM

โ€œcopy-ofโ€ will copy the value of the xml element.

0 Kudos

Go to solution
viktor_n
Contributor II

โ€Ž08-31-2021 07:59 AM

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.

0 Kudos

Go to solution
Sahil
Contributor
In response to viktor_n

โ€Ž08-31-2021 03:59 PM

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.

0 Kudos

Go to solution
pmanchevski
New Contributor II

โ€Ž09-01-2021 01:03 AM

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

Go to solution
Sahil
Contributor
In response to pmanchevski

โ€Ž09-01-2021 01:17 AM

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.

0 Kudos