Merging multiple sheets based on ID and condition

[Chauche]

Hi Team,

I am working on consolidating my workflow results into one Master Identifier sheet but has few conditions.

1) If workflow result have header with "%Field ID" then it should pick up value against the Identifier in the Master Identifier file

2) If workflow result header doesn't contain "%Field ID" and if it find value against Identifier then it should populate "Yes" or "No" as applicable in the Master Identifier File.

SRB, MLT, EBA and FIN are my workflow results which need to be consolidated in Master_identifier file

Sample of required result can be found in Result Sheet.

Hope I am clear in my ask. Please let me know your thoughts and share the sample flow file.

Cheers

[Podoseb0]

Hi, not sure if I'm getting your request right, see the workflow attached.

Basically, the logic I followed is:

if for example FIN has the identifier but there is no value for it, it should show "Yes". If an identifier is present in the Master_identifier but not in FIN, it should show "No". Correct?

[Chauche]

Hi @Podseb0,

Yes, you understanding is correct. but I am not able to import your sheet in Alteryx. 

[Podoseb0]

What do you mean you can't import it? Does it give you some kind of error?

It's a package created on Alteryx 2022.1. If you're on an older version, you should still be aple to open it (although getting some errors because of a different version).

Or you can just change the file extension to .zip, extract the content and then open the workflow you find inside.

[Chauche]

Hi @Podoseb0

Thanks for the help I could import that.

Apologies, for the FIN data actually that have values. The workflow should input "Y" if it finds value against any Identifier in Master File.

Please find the correct attach.

Thanks

[Podoseb0 · Accepted solution]

Oh ok, then you're looking for something like this as a result, correct? (worklow attached)