File choice in App Alteryx

Question

SAP ITGC Workflow - Double accounts & Security Password parameters_V5.yxzp

Hello,

I have created an Alteryx analytic app and I’m stuck on one point:

I would like my Alteryx app to allow the user to either choose “USER_ADDR”, insert the file, and map the fields,

or choose “V_USERNAME”, insert the file, and map the fields.

However, at the moment, my app only works if both options are selected and files are provided for each, which should not be possible.

I tried using radio buttons with a condition tool instead of checkboxes, but this still causes issues with the Union tool in the reporting modules, because it requires a table for each input stream.

I also tried another method to make it so that if the user does not choose any file, an empty file is used instead, containing only the headers. However, this method was not successful either.

Thank you in advance for your answers.

Best regards,

JulienSchanen · Answer

Hello,

Does anyone have another solution?

Thanks you

JulienSchanen · Answer

@OTrieger , Thanks you :) How to add a text input tool before the union without putting it in an other connection of the union ?

OTrieger · Answer

@JulienSchanen

That is happening as the union is expecting some data, what you can do to handle it is:

force Metadata initialization, add a Select tool or Text Input tool before the Union tool to guarantee that the schema exists. This often fixes dynamic workflows.