Skip to main content
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

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

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


Terms & ConditionsCookie settings