Read csv file with header on the second line but keeping the data of first line

[RVDL]

Hi All,

Suppose I have a csv file as per attachment. It contains the following data:

"Account Overview","20221108",,
"Account Date","Country","City","Amount"
"20220930","UK","London","100.25"
"20220930","UK","Birmingham","16.5"
"20220930","France","Paris","50.125"
"20220930","Germany","Frankfurt","123.45"
"20220930","France","Nice","5432.987"
"Total Accounts","5",,

The header starts on line 2. I now need a workflow that does the following:
- Read the csv file.
- For those lines where "Country" = UK, multiply "Amount" by 2.

- Output a csv file as per below:
"Account Overview","20221108",,
"Account Date","Country","City","Amount"
"20220930","UK","London","200.5"
"20220930","UK","Birmingham","33.0"
"20220930","France","Paris","50.125"
"20220930","Germany","Frankfurt","123.45"
"20220930","France","Nice","5432.987"

Thus the output file should include the first line ("Account Overview","20221108",,), and should drop the last line.

Thanks.

[DataNath · Accepted solution]

@RVDL here's what I came up with and as you can see, it's independent of column positions:

[Felipe_Ribeir0 · Accepted solution]

Hi @RVDL 

You are right, i missed it. Here it is, now with this new correction:

[RVDL]

@Felipe_Ribeir0 @DataNath Thanks both. Your solutions give the desired result.