HLOOKUP

1. The screen shot is my data set

2. The column "schedule 1 type" is a IIF formula IIF(IsEmpty([Stage 1 DataLens Trade ID matched]),IIF(IsEmpty([Stage 2
Business mapping]),[Stage 3 Assumption based],[Stage 2 Business mapping]),[Stage 1 DataLens Trade ID matched])

3. In column "stage" I want a formula which brings out which column did the "schedule 1 type" come from was it stage 1, stage 2 or stage 3.

In excel I had to do this manually. Is there a way in Alteryx to build this "stage" column in?

Error Message

Accepted answers

binu_acs

@Barclaysusercds one way of doing this. You can update the stage1 value according to your requirement

Stage_17_05.yxmd

grazitti_sapna

@Barclaysusercds , another way to solve this problem.

I hope this helps!

Thanks!

Barclaysusercds_workflow.yxmd

All comments

binu_acs

@Barclaysusercds one way of doing this. You can update the stage1 value according to your requirement

Stage_17_05.yxmd

DataNath

How do you get on with this? Workflow attached.

Header lookup.yxmd

grazitti_sapna

@Barclaysusercds , another way to solve this problem.

I hope this helps!

Thanks!

Barclaysusercds_workflow.yxmd

Barclaysusercds

Hi - Thanks for helping. The header comes down but not the correct one when I run it. I can see it working in your workflow. Am I doing something wrong?

Barclaysusercds

checking

Barclaysusercds

Thanks. This worked. In my input data I have more fields that you had. At which point do I bring those out so its appears in the output? When I added your workflow it removed the other fields and only kept 5 columns (sch1, type, stages1-3). Thanks

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335