Read column in excel

[nina.wenner]

Hi, I need your help again.

I have an Excel file. All the information is in one column (reference and barcode).

I need the correct barcode for a reference. The reference is different and comes in as input.

Example:

Input = HB0038670 (reference)
Output should be = 12154159 (barcode)

Can you help me with this?

Many thanks in advance.
Nina

[Robinnavinraj_S]

HI @nina.wenner

Can you share your desired output

[Angel_Llull (Angel95)]

@nina.wenner

the corre

Hello @nina.wenner,

You can use Read CSV activity, and then write range activity. After that, you should have two columns.

Is that what you need?

[postwick (Paul Ostwick)]

Read Range into datatable. Add column to datatable. For Each Row in datatable, use split on “,” to get the two values and assign them to the columns (use replace to get rid of the double quotes). Write Range back to the Excel file.

[nina.wenner]

Hi, I have tried to implement it this way but unfortunately it does not work yet. Here is my test workflow.
Test_1.xaml (13.8 KB)

[pravin_calvin (pravin kumar)]

Hi @nina.wenner

As per your requirement i have created a xaml file!

Please refer to the xaml below.

Main.xaml (11.0 KB)

Regards

[nina.wenner]

Hi @pravin_calvin,

perfect it works, thank you.

Best regards