Issue with IF function

2 posts Page 1 of 1

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

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 (15.62 KiB) Viewed 1053 times

Re: Issue with IF function

Support_Rick Support Specialist

Posts: 592

Joined: Tue Jul 17, 2012 2:12 pm

Location: Phoenix, AZ

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

Post Reply

2 posts Page 1 of 1

Return to “Community Forum”