Challenge #5: HR Position Finder Application

[justynam]

My solution

[jlaverne]

Great challenge.

[Fz]

Hey @mickael_gest,

I am tried your solution. It works very well for the first time. But when I try for the second time i have as error message : unable to open file for write.

How we can run woorkflow and regenerate the output??? 

any help please

Thank you 

[mickael_gest]

Hi @Fz,

This appends sometimes (probably a mis close of the document by Alteryx or Excel if you open it right after the workflow has ran).

A advise : don't open it right after the workflox has ran

To solve the problem, you just have to delete the file.

[Fz]

Hello,

sorry i' joined a wrong attached. 

I  want to regenerate a file, and the old one crashes with the news. without deleting the file.

Thank you

[mickael_gest]

Did you change the output file type from csv to excel ?

If you did so, change the "output options" to "Overwrite File (Remove)".

[Fz]

Thank you so much. it's ok.

[mickael_gest]

Great :)

[kvnpt]

Couldn't figure out how to get the dropdown tool to display the list of unique Position Numbers I created, so I copy pasted them into the interface and set it  to manual.  Workflow in spoiler.  App attached.

Spoiler