Forum Discussion
@mtran21, here are 2 hints, based on my experience:
-
“all green” doesn’t necessarily mean your pipeline read or transmitted a file. Different snap configurations (error handling config, etc.) have different behaviors. You’ll need to check your
Pipeline statistics to see if a file was actually read and processed downstream in the pipeline.
-
Some SFTP servers immediately move a file for processing after receiving it in the inbox. So, depending on the target SFTP server configuration, just because you don’t see the file in the inbox after you attempted to transmit it, doesn’t mean it wasn’t delivered. If the delivery was to an outside party system, you need to work with that party to see if they received it.
- dipanjan_pan5 years agoNew Contributor
Thanks a lot @viktor_n …it works
Hi Dipanjan,
You can use the string method charCodeAt
e,g
($Column1.toLowerCase().charCodeAt(0) - 97) + 1
I’m not understanding your example. If Column 2 is supposed to be your rownum() value, why wouldn’t the values be 1, 2, 3, 4, 5 instead of 1, 1, 1, 2, 3?
- dipanjan_pan5 years agoNew Contributor
rownum based on some partition by column. In this case I want the output based on column 1. thats why it is 1,1,1,2,3
Related Content
- 3 years ago
- 8 years ago
- 2 years ago