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
Userlevel 4
+7
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
Userlevel 4
+7
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.