How to handle data with special characters in Data Source step
Hi All, 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. EX1: In Excel: Test1 & Test2 In data source: Test1 &Test2( addingamp;) EX2: 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. Thanks!Solved1.4KViews0likes2CommentsHow to load properties from different sheets (Same Excel File) in Data Source step
Hi All, I'm trying to load properties from different sheets(Same File) in data source step but it's automatically changing sheet name for all properties, when we change for one. Is that as designed or do we have any other way to do that? Thanks!1.6KViews0likes6Comments