How we can build Alteryx flow using Iferror, countif and Vlook

[Learner09]

Hi

I wanted to add a new column in my Alteryx Model. Please refer to the attached file for details.

Thanks,

Mayank

[Jonathan-Sherman]

Hi @Learner09,

I think this is what you're trying to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Jean-Balteryx]

Hi @Jonathan-Sherman ,

I looked at your workflow and there is one line missing in the output. I think you should add the left output anchor of the join tool to the union. That would include all lines.

Cheers,

Jean-Baptiste

[Jonathan-Sherman · Accepted solution]

Hi @Jean-Balteryx,

Nice spot! @Learner09 i've attached an updated workflow.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[Learner09]

Thank you Jean!

[Learner09]

Thank you Jonathan for the help!