Skip to main content
Cadet | Tier 2
April 18, 2022
Question

Hello All I have excel in which 2 column has same name but the values are different . how to query using select statement

  • April 18, 2022
  • 1 reply
  • 85 views
Hello All I have excel in which 2 column has same name but the values are different . how to query using select statement

    1 reply

    Automation Anywhere Team
    July 14, 2022

    Hello,

     

    This is to inform you that it's not recommended to use the same column name in excel because we will not be able to fetch the data or insert the data properly.

     

    But still, you can try using the below query which might help:-

     

    select * from Sheet where column='value'

     

    If you have any questions please let me know.

     

    Thank you,

    Prabhakar Jha