Forum Discussion

WillyPete's avatar
WillyPete
Contributor
7 years ago

Want a single log entry that prints a value from a spreadsheet AND a variable from the Keyword

Trying to pull a value from a spreadsheet and a variable for the keyword test being run and print them as a single log entry.  Can this be done? I cannot program and can only use the predefined comma...
  • Marsha_R's avatar
    Marsha_R
    7 years ago

    The not-so-pretty way would be to add another variable and set it equal to the table data value and then use that new variable in the code expression.

     

    tristaanogre If there's a spiffy trick for this I don't know it.  Any ideas?

     

     

NisHera's avatar
NisHera
Valued Contributor

most simple way to extract data from excel is using DDT

can use log message to log entry.

 

If you are going to use automation testing then you have to get to know basic programming concepts.

It's not rocket science. I know ppl from different back grounds started manual testing, then learned automation. 

 

tristaanogre's avatar
tristaanogre
Esteemed Contributor
7 years ago

Marsha_R's answer is the best answer... it's not writing code per se where you are writing a function or routine, but to do what you want, you will need to write a code expression.  That's the only way to concatenate strings into a single parameter for the Log.Message operation.

 

And, as NisHera suggests... Automated testing IS programming... it is software development.  You are developing software that tests other software.  So, in truth, to be an test automation engineer, you need to have skill sets from both disciplines.  For that matter, even a good manual tester, to truly know what the various scenarios are that need tested, should have a basic understanding of how code is written.

 

I'd highly recommend starting with a free tutorial... plenty available online.  One for JavaScript can be found at http://www.w3schools.com/js/.