Convert row into header

Help Activities
, , , ,
1

Is it possible to convert the 4th row of an existing datatable a header like you would manually in Excel?

2

Lets assume following:

*a datatable with header names

  • the values from fourth datarow should be used as column names

grafik
grafik

item = YourDataTableVar.Rows(3).ItemArray
YourDataTableVar.columns(idx).ColumnName = item.toString.trim

afterwards remove the fourth row from the datatable

3

image

image

Left side of assign is: columnItem.ColumnName
Right side of assign is: myDT.Rows(3)(columnNum).ToString

4

should i insert something in the “columnItem” part or will that just be the variable?

5

is “idx” a variable or that’s the position of the row?

6

The For Each activity creates it as a variable for you, based on whatever you put into the ForEach field.

7

idx is the name of the variable he’s using to give the For Each somewhere to store the Index of the current row of the loop.

8

not the index of the row, but the index/position of the looped column / item from the itemarray

grafik
in the itemArray we get all columnvalues from the datarow

over this we do loop and using the idx (0,1,…) representing the current loop index for updating the columnname

grafik

2 Likes
9

image
image954Ă—443 26.3 KB

image

Do you know why it says this for each is not set to an instance of an object? It is in an Excel Application scope.

Assign = SoF.Columns(3).ColumnName = Item.ToString.Trim

SoF is the datatable name

10

You’ve conflated his solution with my solution.

You have the For Each set to System.Data.Datacolumn but that’s only for my solution, not PPR’s.

11

we do see from screenshot, that TypeArgument is set to System.Data.Da…

but we had shown different settings:
grafik

Also we had set the idx

And much more differences are to correct

Check the Variable Scope from the datatable when doing the read range and set it to a higher level

12

oh youre right. thank you