Get column 1 value instead and change to row

Help Studio
1

Name of School xx
Name of FP yy
Type of Query aa
Date In
Query Question bb
Query Solution cc

Hi this is my extracted datatable

I would like to get my column 1 value instead
and change this to an row how can i do it ?

2

Hi @xxGoRpa

You can follow this video and replicate the Linq query to transpose the datatable

Regards

1 Like
3

need to transpose the current DT
and use for each to get columns 1
@vrdabberu has mention how to transpose use that

4

Hi @xxGoRpa

use the above video steps to transpose the current DT and once the transpose is done then use the for each row in data table and pass the DT variable of the transposed one and then use the CurrentRow(0).tostring in the loop and you will be able to get the First Index column values.

Regards

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.