I am pulling in several fields from excel and splitting the columns out to fields on a webpage. There is one of those split values that need to be pasted more than once - as in generating a password. What options do I have to get that value in two boxes. It will paste in the first cell, tab to the next cell but nothing happens. Eventually the wizard will move past that point.
Solved
Split command - paste value twice
+5Best answer by JJMedina
The information you are extracting from excel should be already split through the column and row delimiters, for then use the get array data advance command to define each column element (using the same column delimiter). And define each element as a variable.
If I understand correctly, and you are pulling your excel values into different values depending on the excel heading.
If you are targeting your application through the recorder:
- You can append new recording step clicking on the second box, and adding an input text advanced command with the variable you want to set, which will be the same of the previous step.
If you are targeting your application with HTML advance commands:
- You can insert a HTML set value advance command targeting the second box with the same previous variable.
I hope it helps.
Best.
- Nintex Employee
- 3 replies
- Answer
The information you are extracting from excel should be already split through the column and row delimiters, for then use the get array data advance command to define each column element (using the same column delimiter). And define each element as a variable.
If I understand correctly, and you are pulling your excel values into different values depending on the excel heading.
If you are targeting your application through the recorder:
- You can append new recording step clicking on the second box, and adding an input text advanced command with the variable you want to set, which will be the same of the previous step.
If you are targeting your application with HTML advance commands:
- You can insert a HTML set value advance command targeting the second box with the same previous variable.
I hope it helps.
Best.
Translate
+5Well, actually, I started out with the get array data command but changed to split. It hasn’t worked as well using split command. I will change it to the get array data and see how that works! I really appreciate your assistance. How kind of you!
Translate
+5JJ - now something is odd and I don’t know how to fix it. I am using the the get array data but it is pulling in the last row of my excel document and when it processes it, the wizard ends as it should. But I don’t know how to get it to process the other rows on the spreadsheet. The ‘get array data’ is in a loop table.
Translate
+5JJ - One more question- The get array data command for the passcode is the last of four fields we are pulling from excel. When the passcode moves over to the website, it is pulling the passcode and the first field of the next line, separated by the row delimiter. My computer does some wacky things at times but I am not sure if this is one of them or if I have something wrong with my commands. Does this sound familiar? I am using the ‘get array’ command for all of the four fields I am bringing in from excel.
Translate
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.