Cannot find column [Club Member] exception

Learning Hub Academy Feedback
, ,
1

Hello ,
I am getting a run time execution error that cannot find column [Club Member].
please help me for this…

column_not_found
column_not_found1366×768 79.3 KB

2

Hi @parvati,

Please check for any whitespace or special characters in the excel column name .

Regards,
Nimin

3

In the Column name “Club Member” there is a space , so what I have to do for that , any syntax for that?

4

He meant is there any white space in column name in excel sheet other than space between Club and Member

Also try Column Index instead of name as a workaround

Or attach your code so that I can help

Thanks,
Prankur

2 Likes
5

Other than that there is no white spaces or special character.

6

can u please explain me how to try with a index instead of name?
and how to see a code for assign activity.

Thanks,
Parvati

7

Index starts from 0, count from zero and see what is the index of Club Member

Thanks,
Prankur

1 Like
8

index for Club Member is 2 , but in the assign activity how to write synatx for this?

Thanks,
Parvati

9

Please show me what do you want to achieve or the code

10

do you want workflow or sequence snapshot for which i m getting error.

Thanks,
Parvati

11

Hi,

If you want to use Index you can use assign activity where you are proving column name as “Club Member” provide the index.

If you want to use Column name, first see how uipath is printing the column name by looping through the columns from the datatable in for each and print column names and see if any spaces are there in column name and then use Column name “Club Member” in assign statement based on the above printed column names from for each loop

12

Hi @parvati,
If you are using For Each Row activity, then the row variable can only use index ie either 0,1,2,…
So if you consider you have 4 columns like ColA,ColB,ColC,ColD and you want data of ColD, then use row(3).toString. I think you cannot use the column name in it.

13

assign
assign839×589 32.2 KB

In the above snapshot , for the marked assign activity i m getting error.

Thanks,
Parvati

14

image
image1004×559 22.7 KB

The value(Condition) in the assign acitivity , i had provided.

Thanks,
Parvati

15

can u please see my error in teamviewer?
so that i will also get to know where i m doing mistake.

Thanks,
parvati

16

Hi @parvati,

It’s look like your column name contains invalid characters. If your column name in excel sheet is “Club Member”, please use name.Select("[Club Member]='yes'")
If it doesn’t solve your problem, please share the screenshot of the excel column.

Warm regards,
Nimin

17

Hello @nimin
below is my scrrenshot of excel column.

excel_column
excel_column1339×674 33.6 KB

Thanks,
Parvati

18

Hi @parvati,

Please use name.Select("[Club Member]='yes'")

Regards,
Nimin

19

But i had created the variable name as “names”.

Thanks,
Parvati

20

Hi @parvati,
sorry, then you can proceed with names.Select("[Club Member]='yes'")
:grinning:

Warm regards,
Nimin