About an excel

I have an output sheet generated from an process now i need few columns of data to used in as input for another process

Output from process 1 looks like this :

PROCESS 1 OUTPUT.xlsx (9.4 KB)

input should be like
Inputsheet.xlsx (9.9 KB)

where for Canada its should be CA , United Kingdom - GB , and United states - US in column 1

then add the other 3 column same way as it is there then under start date and end date

should be 1st day of month and last date of month same for other rows

data can increase or decrease no duplication in name of country

Hi @mint

Where does SKU, QTY1,QTY2 come from?

Regards

@vrdabberu this will be fixed

Hi @mint

Check out the below workflow:
Sequence4.xaml (12.1 KB)

Output:
PROCESS 1 OUTPUT.xlsx (9.8 KB)

Regards

2 Likes

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