Question

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

  • 15 June 2022
  • 2 replies
  • 19 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

Define Index? First column: Index 0

Userlevel 3
Badge +7

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

Reply