Skip to main content
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
  • 152 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
Forum|alt.badge.img+10
  • 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