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 DiscussionsPagination and nextCursor in headerJavascript to promote top level listsSolvedGoogle Sheets Subscribe questionsBasic string transformations not workingSolvedCan we generate XML file in pretty print format using native snapLogic snaps?Solved
