How to handle this exception

[mhk15 (mehak)]

datatable contains two different columns with same data. So this exception is thrown:

[indra]

Follow below link

Message: column name 'Cash In' does not belong to a table

@Sohaib786, Confirm these things once, Check your CSV Column Names containing any space(s) ? Are you reading the correct sheet where your column is present ? Any spelling mistakes while accessing your column name ? Note: If not, sharing your excel/xaml/screenshot would be helpful. Regards, Dominic

[balupad14 (Balamurugan)]

Hi @mhk15,

Can you share the xml ?

Regards
Balamurugan

[rajeev85 (Raj)]

Hi @mhk15

Looks like you have set Add Headers to True for the Read Range activity. This means the first row of the Excel will be considered as Column Headers in the DataTable (the output of Read Range), apparently in your Excel the first row doesn’t seems to be a Header but a value (going by 9.00 %74.90.). And these value is duplicating within the first row. A DataTable’s Column header cannot duplicate (Case-sensitively)

One Solution is you can build the DataTable first by creating the Columns with its Headers by giving unique Column header names and then use in the Read Range activity