Merging multiple sheets based on ID and condition

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

Altery_Test.xlsx

Reporting

Transformation

Accepted answers

Podoseb0

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

MergeSheets.yxzp

All comments

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?

MergeSheets.yxzp

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

Altery_Test.xlsx

Podoseb0

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

MergeSheets.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703