2 Replies Latest reply on Jan 4, 2017 10:30 PM by Dhruv Gupta

    White spaces creating issue while joining two sheets from excel file

    Nutan Patel

      Hi Experts,

       

      I am facing white space issue while joining two sheets from the excel file. Convert to Custom SQL option is also not available for Excel source I guess otherwise I can use TRIM() function to remove this white spaces. Can anyone help me to remove this white space and get desired output ?  I can do it in excel by adding new field and using TRIM() function but I do not want to do any modification in data source. Also I am preparing city wise employee demographic map, please share example if any.

       

      Thanks

      Nutan Patel