Using Assign between Datatables

[Florent_Salendres]

@AlienV

then follow with an Add Row activity to TableA, then TableB will have the same row count even though I have not done another assign statement?

Correct

@AlienV

What if Table B is emtpy and I want it to have Table A data but be an independent entity? Do I use a populated TableA with the Clone method?

If you expect this different entity to have the same columns (including type), clone is a good approach yes.
It is also fine to have a second “Build data table” in that case, especially if you want types to change.

@AlienV

I was trying to think of the easiest way to convert certain table columns from string to integer by using an assign. I’ve built a datatable and force the contents of web extraction to specific datatypes by assigning to my built table vs a generic blank one. I wanted to do similar but with existing tables.

AFAIK, you cannot change an existing column type, however you can remove it and add a new one with some (relatively complex, depending on how familiar with .Net you are).

I will break it down for you.

• Step 1 ==> Convert your column to an array (in my case i am doing Integer > String, you will have to slightly change the expression)

Column2Values = dt.AsEnumerable.Select(Function(r) r(1).ToString).ToArray
in your case you will use
dt.AsEnumerable.Select(Function(r) Cint(r(1))).ToArray

• Step 2 ==> Remove your column and add a new one, of your type.
  If you need to replace it at a specific position, you can use the approach bellow based on SetOrdinal

Insert a Column into a specific position in DataTable

Hi @naotosx, I have specified the position of the column using the method setOrdinal in the invoke method activity: [image] The DataColumn.SetOrdinal(Int32) method changes the ordinal or position of the DataColumn to the specified ordinal or position. When you change a column’s ordinal, the column is moved to the new position in the collection of columns. Any columns between the previous and new ordinal will be renumbered, to adjust for a column’s new ordinal. Best Regards, Susana

• Step 3 ==> Make a “while” loop with counter that increments the counter at the end of its body

The value expression is:

dt.Rows(index)("Column2String") = column2Values(index)

Basically, you target the row from the datable at the index of the counter, from this row your target the new Column name and you set it’s value with the object with the string at the (string, in my case) at the index of the counter.

Hope this somewhat makes sense

I’m also attaching you xaml example.

God, been a while i did not write a Clayton post

Sequence1.xaml (11.0 KB)

Cheers