Clone a Datatable and then remove Columns of the new datatable

Help Studio
1

Hello, everyone,
I would like to output a data table (type: System.data.datatable) as CSV but without some columns.
but I have to clone the data table first because I still have to work with it
Step1:
Assign:
Datatable_clone = Datatable
Step 2:
“remove Data column” activity (DataTable: Datatable_clone, ColumnName: “Password”)
Step3:
Write CSV

It works so far but no matter what I do, the column “Password” in both datatables are always deleted. Are they still connected or what do I have to do ?

Greetings

Scathara

2

Hi @Scathara1

You need to change your step 1 as below.
Datatable_clone = Datatable.clone
Otherwise, their contents always are changed simultaneously.

2 Likes
3

Thanks :slight_smile:

4

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