Convert Excel file columns into rows

Help
1

Hi guys,

I have the following problem that I want to solve using UiPath. I have an Excel file with a structure like this:

Capture1

What I want to achieve using data manipulation is something like this using the table above:

image

Any ideas?

Thanks

2

This will require some datatable / string manipulation for the columns. You can loop through each column for transaction number and add data rows accordingly with the associated value. You can build an array that consists of operator, transaction, date.

3

Hi @CP2208

May be this pseudo code might be helpful

image
image1219×352 14.7 KB

4

Hi,

Thanks for your answer.

The problem is that, “Transaction date” was just for the example in the real date I have something like Process1-date1, Process1-date2, Process2-date1.

The same logic through 80 columns with different name

5

Hi,

Yes, I tried something like this but I’m not getting the result that I’m looking for.

The result with my script is something like this if you consider the example above

image

Any idea of a possible script for this?

6

@CP2208

Use only “date” in the if condition instead of “transaction_date” then it will take column names with transaction_date , process_date etc find the unique name and use that. Just convert to uipath activities and run it n let me know