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 DiscussionsWay to lock down in Prod org to "Monitor" only access?trace API and proxy callsPagination Logic Fails After Migrating from REST GET to HTTP Client SnapSolvedPipeline Execute Pool sizeSolvedConcat values of a field based on value of another fieldSolved
