Skip to main content
Nintex Community Menu Bar

Excel

  • September 11, 2020
  • 36 replies
  • 167 views

Show first post

36 replies

  • Author
  • August 29, 2022

solved the problem, via the if else function here is the robot I am working on


  • August 29, 2022

Great job!


  • Author
  • August 29, 2022

Thank you teacher for your help!!!!? ?


  • Author
  • August 29, 2022

How to insert obtained dynamic data relative to static variable in Excel


  • August 29, 2022

Hi, I'm not sure what you mean. Are you asking how to insert Excel formulas?


  • Author
  • August 29, 2022

 

don't understand how to add data to static data by numbers from dynamic data


  • August 29, 2022

Still not quite clear, but based on what I see and your arrows you are trying to:

 

For each number in column B, find the same number in column J, and move the matching number in J to the same row as the number in column B

 

Is that right?


  • Author
  • August 29, 2022

Yes ,this is true)

 


  • August 29, 2022

Ok, here is some sample LWIZ code that does what is described above. You can see that the values on the right are now aligned with those on the left.

 

Before:

 

After:


  • August 29, 2022

And the sample Excel used with it. I hope this helps


  • Author
  • August 29, 2022

Interesting implementation, I will study, thanks teacher,

how to open lwiz files I'll leave here

https://community.kryonsystems.com/s/question/0D51o00006oiwSyCAI/how-to-restore-a-wizard-from-lwiz-file-files-in-autosave-folder