database Lead/Lag functionality in shell scripting Unicorn Meta Zoo #1: Why another podcast? ...

My bank got bought out, am I now going to have to start filing tax returns in a different state?

"Rubric" as meaning "signature" or "personal mark" -- is this accepted usage?

What is the term for a person whose job is to place products on shelves in stores?

What is the least dense liquid under normal conditions?

What’s with the clanks in Endgame?

Mistake in years of experience in resume?

Justification for leaving new position after a short time

What ability score does a Hexblade's Pact Weapon use for attack and damage when wielded by another character?

Could moose/elk survive in the Amazon forest?

What is this word supposed to be?

With indentation set to `0em`, when using a line break, there is still an indentation of a size of a space

How do I check if a string is entirely made of the same substring?

Does Mathematica have an implementation of the Poisson binomial distribution?

Map material from china not allowed to leave the country

PIC mathematical operations weird problem

Multiple options vs single option UI

Passing args from the bash script to the function in the script

Do I need to protect SFP ports and optics from dust/contaminants? If so, how?

Raising a bilingual kid. When should we introduce the majority language?

Seek and ye shall find

My admission is revoked after accepting the admission offer

Why didn't the Space Shuttle bounce back into space as many times as possible so as to lose a lot of kinetic energy up there?

How to translate "red flag" into Spanish?

Could Neutrino technically as side-effect, incentivize centralization of the bitcoin network?



database Lead/Lag functionality in shell scripting



Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar Manara
2019 Community Moderator Election Results
Why I closed the “Why is Kali so hard” questionHow to implement retry mechanism while executing the server url in the shell script?Checking the status of custom services with a scriptScripting multi-volume (GNU) `tar` with pre-defined number of volumesStarting an interactive shell as an asynchronous process (signal delivery)Fcs synchronization error monitoringMatch one cell and replace value of another cell in csv using shell scriptMathematical calculation from different files inside directory using for loopGet the latest timestamp from a set of files based on first line in a fileCreate a script to check the date, time and string and trigger a mailHow to get du -ksh working without a carriage return in shell-scripting?





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}







-2















"EVENT_ID","EVENT_CD","STATUS","QUEUE_TS","START_TS","END_TS"
237686,"XYZ_END","completed","2019-04-23 23:52:12","2019-04-24 04:08:36","2019-04-24 04:08:38"
237685,"XYZ_RFR1","completed","2019-04-23 23:52:12","2019-04-24 04:07:19","2019-04-24 04:08:33"
237684,"XYZ_RFR","completed","2019-04-23 23:52:12","2019-04-24 04:04:48","2019-04-24 04:07:15"
237683,"XYZ_LOAD","completed","2019-04-23 23:52:12","2019-04-24 03:55:58","2019-04-24 04:04:45"
237682,"XYZ_TRUNC","completed","2019-04-23 23:52:12","2019-04-24 03:55:15","2019-04-24 03:55:50"
237681,"XYZ_START","completed","2019-04-23 23:52:11","2019-04-23 23:55:00","2019-04-23 23:55:07"


I have the above CSV file. I need to check both start and end date time for all the events should be completed as per
the order. If there is any mismatch with the sequence of completion , then will return "Issue in load sequence"
else it will return "Load sequence completed sucessfully. I need to do this in a shell scripting.










share|improve this question









New contributor




user349888 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.



























    -2















    "EVENT_ID","EVENT_CD","STATUS","QUEUE_TS","START_TS","END_TS"
    237686,"XYZ_END","completed","2019-04-23 23:52:12","2019-04-24 04:08:36","2019-04-24 04:08:38"
    237685,"XYZ_RFR1","completed","2019-04-23 23:52:12","2019-04-24 04:07:19","2019-04-24 04:08:33"
    237684,"XYZ_RFR","completed","2019-04-23 23:52:12","2019-04-24 04:04:48","2019-04-24 04:07:15"
    237683,"XYZ_LOAD","completed","2019-04-23 23:52:12","2019-04-24 03:55:58","2019-04-24 04:04:45"
    237682,"XYZ_TRUNC","completed","2019-04-23 23:52:12","2019-04-24 03:55:15","2019-04-24 03:55:50"
    237681,"XYZ_START","completed","2019-04-23 23:52:11","2019-04-23 23:55:00","2019-04-23 23:55:07"


    I have the above CSV file. I need to check both start and end date time for all the events should be completed as per
    the order. If there is any mismatch with the sequence of completion , then will return "Issue in load sequence"
    else it will return "Load sequence completed sucessfully. I need to do this in a shell scripting.










    share|improve this question









    New contributor




    user349888 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      -2












      -2








      -2








      "EVENT_ID","EVENT_CD","STATUS","QUEUE_TS","START_TS","END_TS"
      237686,"XYZ_END","completed","2019-04-23 23:52:12","2019-04-24 04:08:36","2019-04-24 04:08:38"
      237685,"XYZ_RFR1","completed","2019-04-23 23:52:12","2019-04-24 04:07:19","2019-04-24 04:08:33"
      237684,"XYZ_RFR","completed","2019-04-23 23:52:12","2019-04-24 04:04:48","2019-04-24 04:07:15"
      237683,"XYZ_LOAD","completed","2019-04-23 23:52:12","2019-04-24 03:55:58","2019-04-24 04:04:45"
      237682,"XYZ_TRUNC","completed","2019-04-23 23:52:12","2019-04-24 03:55:15","2019-04-24 03:55:50"
      237681,"XYZ_START","completed","2019-04-23 23:52:11","2019-04-23 23:55:00","2019-04-23 23:55:07"


      I have the above CSV file. I need to check both start and end date time for all the events should be completed as per
      the order. If there is any mismatch with the sequence of completion , then will return "Issue in load sequence"
      else it will return "Load sequence completed sucessfully. I need to do this in a shell scripting.










      share|improve this question









      New contributor




      user349888 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      "EVENT_ID","EVENT_CD","STATUS","QUEUE_TS","START_TS","END_TS"
      237686,"XYZ_END","completed","2019-04-23 23:52:12","2019-04-24 04:08:36","2019-04-24 04:08:38"
      237685,"XYZ_RFR1","completed","2019-04-23 23:52:12","2019-04-24 04:07:19","2019-04-24 04:08:33"
      237684,"XYZ_RFR","completed","2019-04-23 23:52:12","2019-04-24 04:04:48","2019-04-24 04:07:15"
      237683,"XYZ_LOAD","completed","2019-04-23 23:52:12","2019-04-24 03:55:58","2019-04-24 04:04:45"
      237682,"XYZ_TRUNC","completed","2019-04-23 23:52:12","2019-04-24 03:55:15","2019-04-24 03:55:50"
      237681,"XYZ_START","completed","2019-04-23 23:52:11","2019-04-23 23:55:00","2019-04-23 23:55:07"


      I have the above CSV file. I need to check both start and end date time for all the events should be completed as per
      the order. If there is any mismatch with the sequence of completion , then will return "Issue in load sequence"
      else it will return "Load sequence completed sucessfully. I need to do this in a shell scripting.







      shell-script shell






      share|improve this question









      New contributor




      user349888 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      user349888 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited 1 hour ago









      Rui F Ribeiro

      42.3k1485143




      42.3k1485143






      New contributor




      user349888 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 1 hour ago









      user349888user349888

      1




      1




      New contributor




      user349888 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      user349888 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      user349888 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes












          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "106"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          user349888 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f515372%2fdatabase-lead-lag-functionality-in-shell-scripting%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          user349888 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          user349888 is a new contributor. Be nice, and check out our Code of Conduct.













          user349888 is a new contributor. Be nice, and check out our Code of Conduct.












          user349888 is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Unix & Linux Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f515372%2fdatabase-lead-lag-functionality-in-shell-scripting%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Taj Mahal Inhaltsverzeichnis Aufbau | Geschichte | 350-Jahr-Feier | Heutige Bedeutung | Siehe auch |...

          Baia Sprie Cuprins Etimologie | Istorie | Demografie | Politică și administrație | Arii naturale...

          Nicolae Petrescu-Găină Cuprins Biografie | Opera | In memoriam | Varia | Controverse, incertitudini...