Error using studio x during vlookup activity

Help StudioX
,
1

hi, mayi ask if anyone can help me on this? im using studio x community.

error
error1476Ă—736 29.5 KB

m automation start with text file then i convert into excel

2

HI,

What type of variable did you set at SaveTo (OutputTo) property?
It may solve it, if set string type variable.

Regards,

3

Hi @Nur_Amin

Can you specify what are you trying to do.

Regards

4

image
image1208Ă—496 27.4 KB

hi, where can i check that?

5

hi my activity vlookup has errror regarding string

6

@Nur_Amin

Can you share the excel file the value you are trying to lookup.

Regards

7

Hi,

Can you try to create string (text) type variable, then set it at SaveTo?
Next, assign it to CurrentRow.ByField(“Segment”) as the following?

image
image1202Ă—501 36.6 KB

Regards,

1 Like
8

hi how to create string?

9

HI,

We can create new variable as String in DataManager panel.

image
If there is no DataManager panel, can you share your version of StudioX?

Regards,

10

image
image1251Ă—618 37.3 KB

do i have to create new variable for string?

11

my data manager look a bit different

12

Hi,

The above seems no problem. Please set variable1 at SaveTo property. Next use SetVarableValue activity like CurrentRow.ByField("yourColumn") = variable1

Regards,

13

hi i have try and successful but the output become #N/A

14

Hi,

Perhaps, you should review your settings of VLookup activity.
For now, can you check if each input value is same what you expect, using MessageBox activity etc?

Regards,

15

hi may i know how to check?

16

Use MessaegBox activity to set the following, just before VLookup activity

image

17

hi, sample as below. group is what i want to lookup

code Group
1 Small
2 Large
3 Big

18

@Nur_Amin
If possible can you the excel file.

Regards,