How to handle data with special characters in Data Source step
Have a excel sheet with data where we have special chars(&,<,>..), when loading data to data source it's not loading as it is from excel, it's adding some other junk data like below.Would like to get as it is from excel.
In Excel: Test1 & Test2
In data source: Test1 & Test2( adding amp;)
In Excel: <Positive Test>
In data source: <Positive Test> (loading <, > instead of <, >)
Please let me know, if any one have any idea to handle this.