1 BEST ANSWER
Helpful Answers
Hi Chetan,
I was able to replicate the scenario and get the desired output. I believe the information provided in below screenshots will be helpful.
I'm fetching Days, Hours, Minutes and Seconds in separate data items which you may use further as per your requirement.
Choice stage:
Multi calc stage:
For each multi calc stage, update first line with corresponding text value (Day, Hour etc.). Note that I have not used plural terms so that when the input is singular like '1 Hour', it will also be captured.
In the second line, +4 is mentioned to skip the term 'Day' or 'Days'. For each multi calc stage, update this value accordingly. If needed, I can provide screenshots of the remaining multi calc stages.
------------------------------
Arun K J
------------------------------
I was able to replicate the scenario and get the desired output. I believe the information provided in below screenshots will be helpful.
I'm fetching Days, Hours, Minutes and Seconds in separate data items which you may use further as per your requirement.
Choice stage:
Multi calc stage:
For each multi calc stage, update first line with corresponding text value (Day, Hour etc.). Note that I have not used plural terms so that when the input is singular like '1 Hour', it will also be captured.
In the second line, +4 is mentioned to skip the term 'Day' or 'Days'. For each multi calc stage, update this value accordingly. If needed, I can provide screenshots of the remaining multi calc stages.
------------------------------
Arun K J
------------------------------
Hi Chetan,
I was able to replicate the scenario and get the desired output. I believe the information provided in below screenshots will be helpful.
I'm fetching Days, Hours, Minutes and Seconds in separate data items which you may use further as per your requirement.
Choice stage:
Multi calc stage:
For each multi calc stage, update first line with corresponding text value (Day, Hour etc.). Note that I have not used plural terms so that when the input is singular like '1 Hour', it will also be captured.
In the second line, +4 is mentioned to skip the term 'Day' or 'Days'. For each multi calc stage, update this value accordingly. If needed, I can provide screenshots of the remaining multi calc stages.
------------------------------
Arun K J
------------------------------
I was able to replicate the scenario and get the desired output. I believe the information provided in below screenshots will be helpful.
I'm fetching Days, Hours, Minutes and Seconds in separate data items which you may use further as per your requirement.
Choice stage:
Multi calc stage:
For each multi calc stage, update first line with corresponding text value (Day, Hour etc.). Note that I have not used plural terms so that when the input is singular like '1 Hour', it will also be captured.
In the second line, +4 is mentioned to skip the term 'Day' or 'Days'. For each multi calc stage, update this value accordingly. If needed, I can provide screenshots of the remaining multi calc stages.
------------------------------
Arun K J
------------------------------
@Chetan Ninghot
Please find the screenshots of all Multi calc stages below:
It worked for a number of different input values. Please let me know if you are facing any trouble with any particular input.
Days:
Hours:
Minutes:
Seconds:
Note: Give the choice criterions in the same order as I have given for it to work as per the common timestamp logic.
------------------------------
Arun K J
------------------------------
Please find the screenshots of all Multi calc stages below:
It worked for a number of different input values. Please let me know if you are facing any trouble with any particular input.
Days:
Hours:
Minutes:
Seconds:
Note: Give the choice criterions in the same order as I have given for it to work as per the common timestamp logic.
------------------------------
Arun K J
------------------------------
@Chetan Ninghot,
The problem was not with Singular/Plural. It was with the case sensitivity. I have made a small correction to address that.
Please find the corrections below:
1) Added a stage to convert input to Upper case.
2) Changed the terms like day, hour etc in Choice stage to upper case.
3) Changed the terms in all multi calc stages to Upper case. Providing screenshot of multi calc stage for Day in Choice stage below:
Just like this, change the Hour, Minute, and Second to all upper case -> HOUR, MINUTE, SECOND.
This will resolve the issue. Please check next comment for the correct output of the inputs you have mentioned.
------------------------------
Arun K J
Consultant - Automation Developer
WonderBotz India Pvt. Ltd.
------------------------------
The problem was not with Singular/Plural. It was with the case sensitivity. I have made a small correction to address that.
Please find the corrections below:
1) Added a stage to convert input to Upper case.
2) Changed the terms like day, hour etc in Choice stage to upper case.
3) Changed the terms in all multi calc stages to Upper case. Providing screenshot of multi calc stage for Day in Choice stage below:
Just like this, change the Hour, Minute, and Second to all upper case -> HOUR, MINUTE, SECOND.This will resolve the issue. Please check next comment for the correct output of the inputs you have mentioned.
------------------------------
Arun K J
Consultant - Automation Developer
WonderBotz India Pvt. Ltd.
------------------------------
@Chetan Ninghot
A) 1 day 5 hours
B) 5 days 1 hour
C) 9 hour 35 mins
The only difference is, in the process I have built, the keyword used in the choice and the multi calc stage for minutes is 'MINUTE'. If the input you are using mentions it as min or mins, corresponding change needs to be done to mention 'MIN' as the keyword in the choice and in the multi calc stage for minutes criteria . You can make the correction as mentioned in the screenshots below:
Correction in Choice:
Correction in Multi Calc stage of minutes criteria:
Please check and let me know of this resolves your issue.
------------------------------
Arun K J
Consultant - Automation Developer
WonderBotz India Pvt. Ltd.
------------------------------
A) 1 day 5 hours
B) 5 days 1 hour
C) 9 hour 35 mins
The only difference is, in the process I have built, the keyword used in the choice and the multi calc stage for minutes is 'MINUTE'. If the input you are using mentions it as min or mins, corresponding change needs to be done to mention 'MIN' as the keyword in the choice and in the multi calc stage for minutes criteria . You can make the correction as mentioned in the screenshots below:
Correction in Choice:
Correction in Multi Calc stage of minutes criteria:
Please check and let me know of this resolves your issue.
------------------------------
Arun K J
Consultant - Automation Developer
WonderBotz India Pvt. Ltd.
------------------------------
