Forum Discussion

amarnath1234's avatar
amarnath1234
Contributor
6 years ago

data source query

Hi Team,   I have a scnerio where I need to fetch request data from data source and sink the response data in source file.my data is as below.so for below 4 fields we have differenct scnerios in ...
  • avidCoder's avatar
    avidCoder
    6 years ago

    Hi Amarnath,

     

    Could you please try below approach for the issue:-

    1. Format the excel cell and set as "Text". -> Right click on the cell->Format Cells->From Category->Select Text.
    2. And then in groovy code:- String localtyID = ${DataSource#Localty_ID}.

    Hope, this can help you out. Let me know after you try this approach and send the screenshot of the error you get.

avidCoder's avatar
avidCoder
Super Contributor
6 years ago

Hi Amarnath,

 

Could you please try below approach for the issue:-

  1. Format the excel cell and set as "Text". -> Right click on the cell->Format Cells->From Category->Select Text.
  2. And then in groovy code:- String localtyID = ${DataSource#Localty_ID}.

Hope, this can help you out. Let me know after you try this approach and send the screenshot of the error you get.

  • amarnath1234's avatar
    amarnath1234
    Contributor
    6 years ago

    this is working.

     

    thanks.