Issue with IF function

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
2 posts Page 1 of 1

dhascup

Posts: 5
Joined: Mon Mar 24, 2014 9:11 am

Post by dhascup » Fri Apr 01, 2016 8:53 am
My IF function is not working properly

In the productType "CA" comes out as it should
In the packagingType "PK" comes out when it should be "CT"
They both refer to dataItem[7]

Code: Select all
<element name="globalAttributes">
									<element name="productType" value="${dataItem[7]}" trim="both" />
									<element name="globalClassificationCategory" trim="both">
										<element name="code" value="${dataItem[58]}" trim="both" />
									</element>
									<element name="gtinName" value="${dataItem[9]}" trim="both">
										<attribute name="lang" value="en" trim="both" />
									</element>
									<element name="brandName" value="${dataItem[5]}" trim="both" />
									<element name="brandOwnerGLN" value="${dataItem[6]}" />
									<forEach inputRowSetVariable="${dataNetContent}">
										<if test="${dataNetContent[1]} eq ${dataItem[2]}">
											<if test="${dataNetContent[2]} eq ${dataItem[3]}">
												<element name="netContent" value="${dataNetContent[3]}" trim="both">
													<attribute name="uom" value="${dataNetContent[4]}" trim="both" />
												</element>
											</if>
										</if>
									</forEach>
									<element name="packagingType" trim="both">
										<element name="code" value="${If((dataItem[7] == "CA"), "CT", "PK")}" trim="both" />
									</element>

See attachment for captured result


Thanks
David
Attachments
Capture.PNG
Capture.PNG (15.62 KiB) Viewed 4182 times

Support_Rick

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Wed Apr 06, 2016 10:37 am
Dave,

More than likely there are some spaces in the data. Please review and/or remove them and let me know.

Thanks!
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1