How to save the excel file once data has been extracted from applications?

[Raghu_km]

Hi All,

How to save the data separately once data is extracted from different toggle.
Example:-
I have excel file, in first sheet1 5 accounts has been stored
and second sheet2 i have added key and values, after running my workflow the data has been captured in sheet2 and before running second account sheet2 data has been stored in x folder and start next account. i am expecting for 5 accounts 5 excel files in x folder. please help me on this.

thank you.

[arjunshenoy]

Hi @Raghu_km

If you want to create a new file for every account number in the folder X, you can create a new file for each account number iteration from sheet 2:

Sample Workflow:

Hope this helps,
Best Regards.

[Raghu_km]

Hi Arjun thanks for your quick resolutions, your workflow is working. but i am looking in different way.
example of dummy data.
Sheet-1
Account
123
456
789

Shee-2

Key	Values
name	xyz
DOB	12/12/2010
FatherName	ABC
Address	12, zyc das

note - the second sheet2 entire data should copy or create a new file.

[arjunshenoy]

@Raghu_km

So basically you need to create 3 files as per 3 data from sheet 1 & each file should contain the entire data present in sheet 2, am I right? Please let me know.

Best Regards.

[Raghu_km]

Arjun - Yes you’re right

[arjunshenoy]

@Raghu_km

Please find the process where your requirements are met:

FileCreationDemo.zip (160.0 KB)

Output Structure:

Hope this helps,
Best Regards.

[Raghu_km]

Arjun - you’re awesome its working now. thank you so much.