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].
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
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]
See attachment for captured result
Thanks
David
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 4204 times
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
Dave,
More than likely there are some spaces in the data. Please review and/or remove them and let me know.
Thanks!
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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts
Page 1 of 1