Convert Excel Input Data to Output CSV Data

[Sisay_Dinku (Sisay YDG)]

Hi team,

I just wanted to give you a little background about what I’d like to accomplish. Here is the problem that I need to solve using UiPath Studio.

I have an excel input file (Input_Data.xlsx) where we get the data from, excel template (Template_forOutput.xlsx) the format that we need our csv output file to be and CSV output file (Desired_Output.csv) manually populated output file that we’d expect the bot would do the same thing once automated. These examples are attached with this post.
Input_Data.xlsx (11.5 KB)
Template_forOutPut.xlsx (15.7 KB)

CSV file (Desired_Output.csv) could not post on this post.

Just for emphasis purposes: We’d like to repeat the articles and Prices for every price level in the output csv file. Other values like that on the first rows are repeated as is.

Column Mapping between input and output

Input Column Name Output Column Name

Articles – >> STYLE

New Price – >> New Price

                                      -->>    Old Price  (has no input column), the same values under New price are copied

Country – >> SBS

Price Levels – >> Price Level

Start Date -->> Start Date

End Date -->> End Date

File Name -->> Price Change Name

Email -->> EMAIL

                                       -->>     Delete (has no input column)

[Michael.Vornes]

Hi,
Here is a suggestion on how to solve your problem.

1. Read input file and get a list/datatable of “Price Levels”
   

   

2. For each Price Level from the previous list, replicate every article from the input matching with the correct columns in the output
   

   

3. Write results in XLSX and CSV
   
   

   

Hope it solves your problem!

Here is the UiPath project, check it out
Excel_to_CSV.zip (82.4 KB)