How I can I display all values at a time in V11
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
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
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
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
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
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.