Type one name

Help
1

Hi,

I have simple question, I have a variable with names but when I use the type into it types all the names. Is there a way to only type one name? and then the other one etc.

image

Cheers,

2

Name = First_Name Middle_Name Last_Name
then Split the Name by spaces.
In type into activity

  • Name.split(" "c)(0) will give you First_Name
  • Name.split(" "c)(1) will give you Middle_Name
  • Name.split(" "c)(2) will give you Last_Name
1 Like
3

@ukjtenhoven Can you elaborate the scenario from where you are getting type into value and what you needs to type.

4

Hi @ukjtenhoven,

what is the datatype of names variable is it a string array?

5

Hi, @ashley11 @Karun @indra

I think I did not explain it right.

image

These are example names and one by one need to be typed into this:

image

Then it searches information about that person and I need that information per name.

Cheers,

6

step 1: Read the excel file using read range activity you will get a datatable
step 2: Use for each row activity to loop through the above datatable
step 3: Keep that type into activity inside this foreach and pass row(“column name”) to type into

try this and let me know for any queries…

7

from the screenshot you shared i hope that u are using the excel

  1. use read range activity
  2. use foreach row activity
  3. everything what you have to do before typing into the next name those activities you perform inside the for each row activity
8

@ukjtenhoven From where you want to to type names from Gebruiker or ukjtenhoven

9

it will type from empty cell

1
if you check the add headers check box in the read range activity properties.

10

From the Excel file

11

Alright thanks!

12

Alright I think that I got it

Cheers,

13

What exactly do you mean with pass row(“column name”)?

cheers,

14

for example your input excel is like this,

1

row(“Age”) will return 22,25…etc on for each row loop.
In your case, pass row(“Gebruiker”) to type into

15

@ukjtenhoven Is it possible to share your workflow.

16

I’m affraid there is pretty confidential information…

17

Hi,

so you mean like this?

image
image474Ă—832 13.2 KB

Cheers,

18

yes your correct but move for each row to outside from the excel application scope

19

Hi,

But now I get this error do you know perhaps why?

image
image753Ă—221 7.65 KB

Cheers,

20

@ukjtenhoven Try this row(2).ToString in type into activity