Skip to main content
Nintex Community Menu Bar

Excel

  • Sep 11, 2020 6:34 AM UTC
  • 36 replies
  • 218 views
  • Translate All

Show first post

36 replies

  • Author
  • Aug 29, 2022 1:09 PM UTC

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

Translate

  • Aug 29, 2022 1:09 PM UTC

Great job!

Translate

  • Author
  • Aug 29, 2022 1:09 PM UTC

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

Translate

  • Author
  • Aug 29, 2022 1:09 PM UTC

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

Translate

  • Aug 29, 2022 1:09 PM UTC

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

Translate

  • Author
  • Aug 29, 2022 1:09 PM UTC

 

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

Translate

  • Aug 29, 2022 1:09 PM UTC

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?

Translate

  • Author
  • Aug 29, 2022 1:09 PM UTC

Yes ,this is true)

 

Translate

  • Aug 29, 2022 1:09 PM UTC

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:

Translate

  • Aug 29, 2022 1:09 PM UTC

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

Translate

  • Author
  • Aug 29, 2022 1:09 PM UTC

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

Translate