2 string variable from 2 different column to populate a single output column in CSV

Help Activities
, ,
1

My two variable string type which will grab the data from the excel column below:

ME1_POWER = DT_file5_data(i)(“ME1.POWER”).tostring()

image

ME2_POWER = DT_file5_data(i)(“ME2.POWER”).tostring()

image

After that I would do below activities:

image
image549×551 22.5 KB

Where NewRow is a datarow type

NewRow = DT_File5_Output.NewRow()

But my output only write the ME2_POWER, and I think it overwrite the ME1_POWER.
image

My desired output is supposed to have both data from both column under the same new column:
image

I am not sure what I did wrong here, can anyone assist me?

Forum Engagement Daily Reports
2

@Irfan_Musa,

Move this assign activity below Add data row activity and add one more add data row activity below it.

The image shows a sequence of steps in a flowchart with an "Assign" activity highlighted, indicating the assignment of the "ME2_POWER" value to the "MCR_load" field in a data row. (Captioned by AI)
The image shows a sequence of steps in a flowchart with an "Assign" activity highlighted, indicating the assignment of the "ME2_POWER" value to the "MCR_load" field in a data row. (Captioned by AI)1080×1022 106 KB

Thanks,
Ashok :slightly_smiling_face:

3

@ashokkarale its giving me error when I do that

The image shows an error log indicating that an attempt to add a data row to an Excel file failed because the row already exists in the table, resulting in a System.ArgumentException. (Captioned by AI)
The image shows an error log indicating that an attempt to add a data row to an Excel file failed because the row already exists in the table, resulting in a System.ArgumentException. (Captioned by AI)983×140 7.32 KB

4

@Irfan_Musa,

Take the New Row assign activity also below Add data row.

I mean make a copy of the New Row assign activity.

5

@Irfan_Musa

You have to do the seuqence of new row,assign and add data row twice …once for each value you need

Cheers

6

I did them like this, is this what u meant?

The image depicts a sequence of actions in a workflow, illustrating steps to initialize a new row, assign values ME1_POWER and ME2_POWER to the "MCR_load" field, add the new row to the data table DT_File5_Output, and repeat the process. (Captioned by AI)

The image shows a workflow automation process that assigns a value to a data row, adds the data row to an output data table, and writes the final filtered data to a CSV file. (Captioned by AI)

7

I did them like this, is this what u meant?

The image depicts a sequence of actions in a workflow, illustrating steps to initialize a new row, assign values ME1_POWER and ME2_POWER to the "MCR_load" field, add the new row to the data table DT_File5_Output, and repeat the process. (Captioned by AI)

The image shows a workflow automation process that assigns a value to a data row, adds the data row to an output data table, and writes the final filtered data to a CSV file. (Captioned by AI)

8

@Irfan_Musa,

This way please.

The image depicts a sequence of workflow steps in an automation process, involving the assignment of values to a new data row and adding it to a data table in two instances. (Captioned by AI)
The image depicts a sequence of workflow steps in an automation process, involving the assignment of values to a new data row and adding it to a data table in two instances. (Captioned by AI)622×1068 112 KB

Thanks,
Ashok :slight_smile:

9

@ashokkarale The output seems different compare to the one I want

image

My desired output is supposed to have both data from both column under the same new column:

image

It has to populate the ME1_POWER first in the row than the ME2_POWER

10

@Irfan_Musa,

Ohh ok. I think we need to change the approach here.

Use two datatables one for ME1_Power and one for ME2_Power

Once data is filled in these, just before write range, use Merge datatable activity to merge both and then write the final combined output using Write Range

11

How do I create the data table. Currently my ME1_POWER and ME2_POWER are string type

12

Like dt_File5_Output