jmeter - how to skip specific row from csv
I've a csv like this:
NAME;F1;F2;
test1;field1;field2
test2;field1;field2
test3;field1;field2
I would test only test1, so I would change the csv in
ID;F1;F2;
test1;field1;field2
#test2;field1;field2
#test3;field1;field2
how can I skip rows of test2 and test3 in jmeter?
csv jmeter
asked Nov 14 '18 at 9:50
ClaudioMClaudioM
753919
add a comment |
I've a csv like this:
NAME;F1;F2;
test1;field1;field2
test2;field1;field2
test3;field1;field2
I would test only test1, so I would change the csv in
ID;F1;F2;
test1;field1;field2
#test2;field1;field2
#test3;field1;field2
how can I skip rows of test2 and test3 in jmeter?
csv jmeter
asked Nov 14 '18 at 9:50
ClaudioMClaudioM
753919
add a comment |
I've a csv like this:
NAME;F1;F2;
test1;field1;field2
test2;field1;field2
test3;field1;field2
I would test only test1, so I would change the csv in
ID;F1;F2;
test1;field1;field2
#test2;field1;field2
#test3;field1;field2
how can I skip rows of test2 and test3 in jmeter?
csv jmeter
asked Nov 14 '18 at 9:50
ClaudioMClaudioM
753919
I've a csv like this:
NAME;F1;F2;
test1;field1;field2
test2;field1;field2
test3;field1;field2
I would test only test1, so I would change the csv in
ID;F1;F2;
test1;field1;field2
#test2;field1;field2
#test3;field1;field2
how can I skip rows of test2 and test3 in jmeter?
csv jmeter
csv jmeter
asked Nov 14 '18 at 9:50
ClaudioMClaudioM
753919
asked Nov 14 '18 at 9:50
ClaudioMClaudioM
753919
edited Nov 14 '18 at 10:05
ClaudioM
asked Nov 14 '18 at 9:50
ClaudioMClaudioM
753919
asked Nov 14 '18 at 9:50
ClaudioMClaudioM
753919
asked Nov 14 '18 at 9:50
ClaudioMClaudioM
753919
753919
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You cannot, the only option I can think of is creating a new CSV file out of the existing one with just first 2 lines like:
- Add setUp Thread Group to your Test Plan
- Add JSR223 Sampler to the setUp Thread Group
Put the following code into "Script" area
new File('original.csv').readLines().take(2).each {line ->
new File('new.csv') << line << System.getProperty('line.separator')
}
Replace
original.csvwith path to the current CSV file and set up CSV Data Set Config to usenew.csv
The above code will write first 2 lines from the
original.csvinto thenew.csvso you will be able to access limited external data instead of the full CSV file.
More information:
File.readLines()
Collection.take()- The Groovy Templates Cheat Sheet for JMeter
answered Nov 14 '18 at 10:17
Dmitri TDmitri T
71.4k33661
that's what I'm actually doing.. I hope there was a simple way to do something .. if (row ==~ "^#" ) { skip} ..
– ClaudioM
Nov 14 '18 at 10:24
add a comment |
There is always a way to do to something..
maybe my way is not the best and "pretty" but it worth!
- Thread Group
- Loop Controller
- csv Data Set Config
- if Controller
- Http Request
- Loop Controller
Inside If Controller I added this code:
${__groovy(vars.get('ID').take(1)!='#')}
In this way when you put an # at the start of the row it will be skipped.
I hope it could be helpfull for someone.
answered Nov 23 '18 at 22:30
ClaudioMClaudioM
753919
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
});
}
});
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%2fstackoverflow.com%2fquestions%2f53297268%2fjmeter-how-to-skip-specific-row-from-csv%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You cannot, the only option I can think of is creating a new CSV file out of the existing one with just first 2 lines like:
- Add setUp Thread Group to your Test Plan
- Add JSR223 Sampler to the setUp Thread Group
Put the following code into "Script" area
new File('original.csv').readLines().take(2).each {line ->
new File('new.csv') << line << System.getProperty('line.separator')
}
Replace
original.csvwith path to the current CSV file and set up CSV Data Set Config to usenew.csv
The above code will write first 2 lines from the
original.csvinto thenew.csvso you will be able to access limited external data instead of the full CSV file.
More information:
File.readLines()
Collection.take()- The Groovy Templates Cheat Sheet for JMeter
answered Nov 14 '18 at 10:17
Dmitri TDmitri T
71.4k33661
that's what I'm actually doing.. I hope there was a simple way to do something .. if (row ==~ "^#" ) { skip} ..
– ClaudioM
Nov 14 '18 at 10:24
add a comment |
You cannot, the only option I can think of is creating a new CSV file out of the existing one with just first 2 lines like:
- Add setUp Thread Group to your Test Plan
- Add JSR223 Sampler to the setUp Thread Group
Put the following code into "Script" area
new File('original.csv').readLines().take(2).each {line ->
new File('new.csv') << line << System.getProperty('line.separator')
}
Replace
original.csvwith path to the current CSV file and set up CSV Data Set Config to usenew.csv
The above code will write first 2 lines from the
original.csvinto thenew.csvso you will be able to access limited external data instead of the full CSV file.
More information:
File.readLines()
Collection.take()- The Groovy Templates Cheat Sheet for JMeter
answered Nov 14 '18 at 10:17
Dmitri TDmitri T
71.4k33661
that's what I'm actually doing.. I hope there was a simple way to do something .. if (row ==~ "^#" ) { skip} ..
– ClaudioM
Nov 14 '18 at 10:24
add a comment |
You cannot, the only option I can think of is creating a new CSV file out of the existing one with just first 2 lines like:
- Add setUp Thread Group to your Test Plan
- Add JSR223 Sampler to the setUp Thread Group
Put the following code into "Script" area
new File('original.csv').readLines().take(2).each {line ->
new File('new.csv') << line << System.getProperty('line.separator')
}
Replace
original.csvwith path to the current CSV file and set up CSV Data Set Config to usenew.csv
The above code will write first 2 lines from the
original.csvinto thenew.csvso you will be able to access limited external data instead of the full CSV file.
More information:
File.readLines()
Collection.take()- The Groovy Templates Cheat Sheet for JMeter
answered Nov 14 '18 at 10:17
Dmitri TDmitri T
71.4k33661
You cannot, the only option I can think of is creating a new CSV file out of the existing one with just first 2 lines like:
- Add setUp Thread Group to your Test Plan
- Add JSR223 Sampler to the setUp Thread Group
Put the following code into "Script" area
new File('original.csv').readLines().take(2).each {line ->
new File('new.csv') << line << System.getProperty('line.separator')
}
Replace
original.csvwith path to the current CSV file and set up CSV Data Set Config to usenew.csv
The above code will write first 2 lines from the
original.csvinto thenew.csvso you will be able to access limited external data instead of the full CSV file.
More information:
File.readLines()
Collection.take()- The Groovy Templates Cheat Sheet for JMeter
answered Nov 14 '18 at 10:17
Dmitri TDmitri T
71.4k33661
answered Nov 14 '18 at 10:17
Dmitri TDmitri T
71.4k33661
answered Nov 14 '18 at 10:17
Dmitri TDmitri T
71.4k33661
answered Nov 14 '18 at 10:17
Dmitri TDmitri T
71.4k33661
71.4k33661
that's what I'm actually doing.. I hope there was a simple way to do something .. if (row ==~ "^#" ) { skip} ..
– ClaudioM
Nov 14 '18 at 10:24
add a comment |
that's what I'm actually doing.. I hope there was a simple way to do something .. if (row ==~ "^#" ) { skip} ..
– ClaudioM
Nov 14 '18 at 10:24
that's what I'm actually doing.. I hope there was a simple way to do something .. if (row ==~ "^#" ) { skip} ..
– ClaudioM
Nov 14 '18 at 10:24
that's what I'm actually doing.. I hope there was a simple way to do something .. if (row ==~ "^#" ) { skip} ..
– ClaudioM
Nov 14 '18 at 10:24
add a comment |
There is always a way to do to something..
maybe my way is not the best and "pretty" but it worth!
- Thread Group
- Loop Controller
- csv Data Set Config
- if Controller
- Http Request
- Loop Controller
Inside If Controller I added this code:
${__groovy(vars.get('ID').take(1)!='#')}
In this way when you put an # at the start of the row it will be skipped.
I hope it could be helpfull for someone.
answered Nov 23 '18 at 22:30
ClaudioMClaudioM
753919
add a comment |
There is always a way to do to something..
maybe my way is not the best and "pretty" but it worth!
- Thread Group
- Loop Controller
- csv Data Set Config
- if Controller
- Http Request
- Loop Controller
Inside If Controller I added this code:
${__groovy(vars.get('ID').take(1)!='#')}
In this way when you put an # at the start of the row it will be skipped.
I hope it could be helpfull for someone.
answered Nov 23 '18 at 22:30
ClaudioMClaudioM
753919
add a comment |
There is always a way to do to something..
maybe my way is not the best and "pretty" but it worth!
- Thread Group
- Loop Controller
- csv Data Set Config
- if Controller
- Http Request
- Loop Controller
Inside If Controller I added this code:
${__groovy(vars.get('ID').take(1)!='#')}
In this way when you put an # at the start of the row it will be skipped.
I hope it could be helpfull for someone.
answered Nov 23 '18 at 22:30
ClaudioMClaudioM
753919
There is always a way to do to something..
maybe my way is not the best and "pretty" but it worth!
- Thread Group
- Loop Controller
- csv Data Set Config
- if Controller
- Http Request
- Loop Controller
Inside If Controller I added this code:
${__groovy(vars.get('ID').take(1)!='#')}
In this way when you put an # at the start of the row it will be skipped.
I hope it could be helpfull for someone.
answered Nov 23 '18 at 22:30
ClaudioMClaudioM
753919
answered Nov 23 '18 at 22:30
ClaudioMClaudioM
753919
answered Nov 23 '18 at 22:30
ClaudioMClaudioM
753919
answered Nov 23 '18 at 22:30
ClaudioMClaudioM
753919
753919
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53297268%2fjmeter-how-to-skip-specific-row-from-csv%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
