Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Solved

Basic string transformations not working

Hi Team, I observed that basic string transformations are not working, few of the scenarios have been listed below: Trimming spaces from the text Changing the text from uppercase to lowercase...
  • darshthakkar's avatar
    darshthakkar
    3 months ago

    Some of the observations here:

    1. Data coming from upstream systems was messed up

    2. There were added spaces in the data from the upstream systems itself 

    3. Ideally, with snapLogic, it should have been able to trim the spaces and help with the transformations however it wasn't able to do so

    4. Having said that, the mapper and conditional snap works just right for other set of data so giving the benefit of doubt to the messy data coming from upstream systems.

    Some recommendations/suggestions:

    1. If you're using a csv file, please ensure the encoding is supported in snapLogic and select the encoding accordingly

    2. For excel files, it should work just right

    3. For data coming from upstream systems like Oracle, Salesforce or Snowflake, try to export the data and see if there are any discrepancies, if there are, align with your team internally to fix it before connecting it with snapLogic.

    Closing this thread now.

hawkeye412's avatar
hawkeye412
New Contributor II
2 years ago
Copy LinkReport

Aleksandar_A  could you elaborate a bit more on your solution?  I understand how to check the api.  

  • What would you recommend for the wait?  Script snap or something else.  Especially if longer than say 15 min.  You wouldn't want it sitting there all that time.
  • After the wait I would check the API to see if completed but how do you recommend looping back to attempt the retry?
  • Last thing:  Any thoughts on a counter?  So you could set it to retry like 6 times?
  • RoyB's avatar
    RoyB
    New Contributor III
    3 years ago
    Copy LinkReport

    Just to clarify

    This is not a “Null-Safe Access” issue

    I’ve confirmed the data is making it to the update statement