Delete the sheet contents of all excel files saved in a folder using Alteryx

[georgechacko]

Hi,

I have some files saved in a folder. I have to delete the sheet contents except heading (Row 1) of all files using Alteryx work flow. Appreciate if anyone can help me with a workflow.

Thanks in advacne,

George A.C.

[HomesickSurfer]

Modify the workflow by deleting the browse tool.

[atcodedog05]

Hi @HomesickSurfer 

Thats amazing. Should meet the requirement.

I am getting below error even after removing browse.

[HomesickSurfer]

Hi @atcodedog05 

Please check the files.  The error code 1 is thrown in but doesn't 'shouldn't affect the batch process.

I'm not getting any error.

[atcodedog05]

Hi @HomesickSurfer 

I got it now. You can basically copying and renaming the no values. Since i didnt have the no values file from template folder i was getting error.

Then again what if the columns names are different ? 🤔 

Hi @georgechacko 

Can you confirm do they have same column name or different column name ?

[georgechacko]

Hi,

All columns are same.

Thanks

George

[georgechacko]

Hi Homesicksuffer,

Thanks for your help.

I am getting error in Run Button. do we need to save any .bat file in the folder? Can you please tell me what path as Write source and Run External program Command of Run button? 

eg:

I have saved all my excel files are in H:\George\Test

File Names:

a.xlsx

b.xlsx

c.xlsx

Column Headings:

Name

Age 

Mark1

Mark2

Mark3

Total

Appreciate your help

Thanks in advance,

George Chacko

[atcodedog05]

Hi @georgechacko 

Is the column heading fixed?

[atcodedog05 · Accepted solution]

Hi @georgechacko 

I am assuming that the column headers are same.

1. Make sure you place clear file.xlsx and workflow in the same folder. Clear file is copied and renamed to the target file name.

2. Workflow:

Blob Input reads the Clear File.xlsx and renames it to the target file names.

Make sure Clear File.xlsx (file with only headers) and workflow is placed in the same folder.

Hope this helps : )

[georgechacko]

Hi atcodedog05,

This is working fine for me. Thank you so much.

Regards,

George

[atcodedog05]

Happy to help : ) @georgechacko 

Cheers and have a nice day!