3 Replies Latest reply on Mar 15, 2020 3:18 AM by Gajanand Patil

    Trailing Zero for Number from AI Spoon

    Timothy Mobley
      Share This:

      I have a transformation in AI Spoon that extracts values from an excel spreadsheet, transforms mapped values and loads in the AR system (specifically the BMC_InventoryStorage class). My problem is that numbers are showing in the AR system with decimal place values ("4.0" where I want "4"). Seeing this thread, I put '#' in the format column of my Microsoft Excel Input step. The weird thing is that when I run the transformation and examine the preview data, it doesn't show any ".0", but in the AR system the zeros are there. How do I hunt down why/where these zeros are added?