Skip to main content
Question

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

  • March 20, 2022
  • 3 replies
  • 26 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
Forum|alt.badge.img+10
  • 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


  • Author
  • 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
Forum|alt.badge.img+10
  • 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