zebu14
(xavier)
June 15, 2023, 1:13pm
1
Hello,
For a MFT platform, each transfer is tagged with a status_code, based on letters "E" for Ended, "C" for Canceled.
I have to find out the partners with high failure rates over time.
Do you have an idea on how to calculate (and use in visualizations ) the failure rate for each partner, based on the status contained in each doc ?
Example message (the status code is in 5th position) :
"1","I","R","230615 151102","E","0","431","SFTP","EE0F9","GREENTRF","transfer/IN/opaxvgw3","1283223-EE0F9","SFTP_B","$S_EE0F9","GREENTRF","230615 151102","230615 151102","0"
Thank you
lukas
(Lukas Olson)
June 15, 2023, 10:08pm
2
Is this message a single field in your document, or do you have separate fields for each code?
zebu14
(xavier)
June 16, 2023, 7:14am
3
This is a single field.
Here is the mapping if it helps
"1","I","R","230615 151102","E","0","431","SFTP","EE0F9","GREENTRF","transfer/IN/opaxvgw3","1283223-EE0F9","SFTP_B","$S_EE0F9","GREENTRF","230615 151102","230615 151102","0"
"type","direction","mode","date","status","code","size","protocol","source","target","path","file_id","appli_id","source_id","target_id","date_begin","date_end","retries"
system
(system)
Closed
July 17, 2023, 1:54pm
5
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.