How to ignore duplicate column names

Help
,
1

Capture
Capture1535×641 36.8 KB

how should i ignore the column names if i have two duplicate Coolum names

2

Hi,

Unfortunately, there is no way to ignore duplicated column name in ReadRange Activity. There are some workarounds as the following.

  1. Uncheck AddHeaders property then read range without header area.
    We need to use column index number instead of column name.

  2. Read range with AddHeaders property unchecked.
    Then, read first row and set each value as column name. if there are duplicated column name, change its name like “name-1”, “name-2”.
    Finally, remove the first row.

Regards,

3

So is their any way to check the above condition

4

Hi,

I’ll attach simple sample as the following.
Hope this helps you.

Sample20201209_2.zip (9.1 KB)

Regards,

5

Thanks @Yoichi but my trying to find whether their coloums name correct or incorrect but
im facing issue that thier are duplicate columns also
so read range wont read it work

and also i need to get the Coolum name which are incorrect separately

Thank for help ur @Yoichi

6

Hi,

Can you share your worksheet as a file? I cannot get your situation correctly from the above information.

Regards,

7

i sorted it out @Yoichi thank for the help

8

dO you know ,if we are using a if condition with several other Boolean values and if
one value become false its going to else
do you have any idea to get the Booleans value which become false as string

9

Hi,

Can yo try And or AndAlso in condition as the following? (z is boolean variable)

img20201209-3

do you have any idea to get the Booleans value which become false as string

Do you mean like the following expression?

Boolean.Parse("False")

Regards,

10

Screenshot (1)
Screenshot (1)1920×1080 123 KB

here some column are becoming false and some true so i want to find what those becoming false

main poupous is to send a mail mentioning the coloumn name that are not equal

11

Hi,

In this case, perhaps you should use single List instead of variables as the following.

img20201209-4
img20201209-4786×409 13.6 KB

Sequence.xaml (5.8 KB)

Regards,

13

Capture
Capture1863×999 75.8 KB

hi Yoichi

i m getting this error because i have duplicate columns in my dt
how solve this

i try to uncheck the header but i want work
do you have any suggestions

14

Hi,

Can you share your worksheet as a file, if possible? I cannot get your situation correctly from the above information.

Regards,

15

Sure i will you a sample
New Microsoft Excel Worksheet.xlsx (8.8 KB)
need to check if this coloume names are correct when comparing with my matrix if name are incorrect need to find what column is incorrect
hi Yoichi
plz find the sheet

16

Hi,

Is the following what you intent?

Sample20201209-4.zip (8.8 KB)

Regards,

1 Like
17

Thanks its worked @Yoichi for your help in this logic any suggestion to improve my skills too​:smiley::smiley:

1 Like
18

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