Skip to main content
Cadet | Tier 2
March 20, 2022
Question

How I can I display all values at a time in V11

  • March 20, 2022
  • 3 replies
  • 86 views
Hi we are using v11 version, I have one Excel file with two columns data. I want to display column2 all values at a time based on state wise. if I am using inside loop if condition and variable operation with list variable I am getting each state wise with respective districts.but as per the above logic it is one by one district only displaying. My requirement is all districts should display at a time for each state.please suggest me how can I proceed in this scenario.thanks in advance. State Districts AP ANANTAPUR KA MYSUR TN SELAM KL KOTTAYAM AP KADAPA KA KOLAR AP KURNOOL KL KOCHI AP NELLORE

    3 replies

    Ashwin A.K
    Navigator | Tier 3
    March 21, 2022

    Hi @Naveen Kumar​ ,

     

    You could try looping through each item and assign it to Clipboard, followed by a $String:NewlIne$ and then display the final output from clipboard, by assigning the value from Clipboard to a variable.

     

    $Excel Column{"Name"}$ + $String:NewlIne$

     

    Could you give that a try and let us know?

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    Cadet | Tier 2
    March 21, 2022
    Thanks Ashwin. I am using 11 version, I have tried I don't see the option $string:newline$ could you please suggest step by step because I am a new learner
    Ashwin A.K
    Navigator | Tier 3
    March 21, 2022

    Hi @Naveen Kumar​ ,

     

    Could you press F2 and search for anything under Special Characters?

    I think even Enter will work

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com