"Assign" keeps showing the name doesn't exist

Help Studio
,
1

I want to convert Total(data table) to NumbersS(String variable) & HospitalS(String variable) to process the following sequence ( replace text in Word document using variable. There are two words I need to replace and to create 160 different files.)
But the system keeps showing the name doesn’t exist. How can I select the first and second columns separately and assign them to two different variables?

image
image915×632 42.1 KB

The “Total” Table is like below:
Numbers Hospitals
20230401 A
20230402 B
20230403 C
(160 rows)

Thank you for your help!

2

You can try using index instead of name.

NumberS = CurrentRow(0).Tostring
HospitalS = CurrentRow(1).Tostring

2 Likes
3

Thank you for your quick reply!
But the system shows this notification.
image

4

Hi,

Can you try as the following?

CurrentRow["Numbers"].ToString()

Regards,

5

Sure! It shows this
image

6

In the first image CurrentRow is spelt wrong (In assign activity)

test

7

How about the following?

Int32.Parse(CurrentRow["Numbers"].ToString())

Regards

8

Many thanks for your notification. But after using
NumberS = CurrentRow(0).Tostring
HospitalS = CurrentRow(1).Tostring
I still cannot run it. Can you give me another suggestions? Thank you.

9

Here is another error
image

10

Change NumberS variable to Int type.

11

Did you input previous as the following?

 CurrentRow["Numbers"].ToString()

The error shows CurrentIndex

Can you retry it?

12

Can you share the image of properties of for each row activity?

13

Customer Master_0313 v2.xlsx (15.5 KB)
Main.xaml (18.4 KB)
Template.docx (31.9 KB)

Sorry I cannot get the problem. But here is file, could you please help. Many Thanks.

14

Clear the Index property.

image
image1363×488 25.7 KB

And try:

NumberS = CurrentRow(0).Tostring

Or

NumberS = CurrentRow("Numbers).Tostring

Or

NumberS = CurrentRow["Numbers].Tostring

Hope it helps.

15

Hi,

Please just remove NumberS at Index property of ForEachRow. Can you try the following?

Main.xaml (17.9 KB)

Regards,

16

It works!! Thank you!!

1 Like
17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.