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;
}
"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
New contributor
add a comment |
"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
New contributor
add a comment |
"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
New contributor
"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
shell-script shell
New contributor
New contributor
edited 1 hour ago
Rui F Ribeiro
42.3k1485143
42.3k1485143
New contributor
asked 1 hour ago
user349888user349888
1
1
New contributor
New contributor
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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.
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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