HLOOKUP

[Barclaysusercds]

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?

[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