Calculate Client Securrity Hash: Assign: "Cannot Find Column WI5"

Learn Academy Feedback
, , ,
1

Hi all,

I am at uipath academy level 3 Calculate Client Security Hash and getting this error for hours. “Cannot find column WI5”

I check data scraping but cannot find anything.

Is there anyone who can help me about that error? If it will not be problem, i can share my all project.

image

2

And here is the error.

image

@lakshman @KarthikByggari @balupad14

1 Like
3

In the select query, please update query as

Type = ‘WI5’

Please enclose the wi5 in single quotes.

Regards,
Karthik Byggari

7 Likes
5

Hey @KarthikByggari thanks for your attention. But now i am getting another interesting error. Can you please help me about that error again :sweat_smile:

I did not sign it as solution because i don’t want to miss this page. but i will

image
image1877×852 87 KB

6

@mazlumkacar

The select query should be like this.

      WIList = TransactionData.Select("Type ='WI5' AND Status = 'Open'")

Where WIList variable should be of type Array of DataRow

7

Thanks a lot @lakshman but can you please help me again about this one:

1 Like
8

@mazlumkacar

It should be like this.

       out_TransactionItem = dt_workitems(in_TransactionNumber - 1)

Actually index will start from 0 onwards.

9

I did it but this time getting same error at first time. I don’t understand where should i put this index. Cause there is no index.

image
image1889×839 78.4 KB

10

@mazlumkacar

I guess you intialized TransactionNumber with 0 in INIT state ? Please check it once.

If yes then initialize with 1.

11

Set TransactionNumber to 0 in Main workflow.
And in the attached screenshot, change the condition in IF as shown below -

in_TransactionNumber < dt_WorkItems.Count

Regards,
Karthik Byggari

4 Likes
12

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