Skip to main content
Cadet | Tier 2
June 15, 2022
Question

How to get only 2 columns from data table that has many columns and create a new data table using that 2 columns?

  • June 15, 2022
  • 2 replies
  • 193 views
How to get only 2 columns from data table that has many columns and create a new data table using that 2 columns?

    2 replies

    Cadet | Tier 2
    June 15, 2022

    Define Index? First column: Index 0

    Ashwin A.K
    Navigator | Tier 3
    June 17, 2022

    Hi @Pratiksha Pawar​ ,

     

    If you are fetching data from excel, then that can be achieved by connecting to Excel like it were a database and using a Select Query to fetch the columns you are interested in:

     

    SELECT Col1, Col2 FROM [Sheet1$$]

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com