How to obtain a new column with those values

Hello guys.

I’m getting values from “Hoja1” in the excel file with a "REad range " activity and putting them inside “Hoja2”.

The desired output would be a column with mixed values from the column “Lote” and “Serie”

I’m uploading the excel file and the .xaml.
Please, Any idea about how to do it?
Please and thanks.

t.xlsx (16.0 KB)
Main.xaml (11.0 KB)

Hi,

How about the following?

Check the following condition

String.IsNullOrEmpty(CurrentRow("Column7").ToString) Xor String.IsNullOrEmpty(CurrentRow("Column11").ToString)

Then write it to new column

CurrentRow("newColumn") = CurrentRow("Column7").ToString+CurrentRow("Column11").ToString

Sample20230210-2.zip (30.7 KB)

Regards,

1 Like

That’s awesome. Just 1 favor, please.

Is there a way to maintain the name “new Column” because It is disappearing?

HI,

Because in the original file write it without header.
For now, can you try to add the following expression just after AddDataColumn activity?

dtConsolidadoOoutput.Rows(0)("newColumn")="name"

Regards,

1 Like

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