dipanjan_panNew Contributor5 years agoScenario to achived rownumber function in sql How can I achieve rownum() funtion in Snaplogic? I have a input data Column 1 a b c a a need output Column1 Column2 a 1 b 1 c ...Show More
alchemizContributor III5 years agoHi Dipanjan, You can use the string method charCodeAt e,g ($Column1.toLowerCase().charCodeAt(0) - 97) + 1
alchemizContributor III to alchemiz5 years agoMy bad, I thought column2 is base from the character from column1 🙂
alchemizContributor III to alchemiz5 years agoMy bad, I thought column2 is base from the character from column1 🙂
Recent DiscussionsGenerate expression file from database queryCan we generate XML file in pretty print format using native snapLogic snaps?Solved401 error with HTTP Client and NTLMPagination and nextCursor in headerJavascript to promote top level listsSolved
