Dynamic referencing of fields

Hi community,

I am pretty new to Alteryx and so apologies in advance if the my question is fairly easy or has been referenced in other threads.

I have a data set, a fairly abridged version of which is as below:

Name Field#1 Field#2 Field#3 Field#4

A null 1234 null Field#2

B 1234 null null Filed#1

C null null 1234 Filed#3

To summaries, columns Field#1, Field#2, Field#3 are the ones that have actual data and there is a Field#4 that has been added to point which filed has the data. The reason as to why I have to add Field#4 is because the data stream owner wants the column "selector" to be outside Alteryx (and sitting in an excel file). With that thought, how can I convert the text 'Field#2' in Field#4 to its corresponding value without reapplying the column selector logic again?

Thanks in advance for looking into this!

Datasets

Accepted answers

AngelosPachis

Hey @Gavaksh ,

Maybe the following workflow will do it?

Same logic as before, but with an extra join since we want to have to separate input streams.

Let me know if that works for you.

Cheers,

Angelos

example_v2.yxmd

All comments

AngelosPachis

Hey @Gavaksh ,

You can achieve this by transposing your data in columns Field1,2,3 on a vertical axis and the using a Join tool, joining on both Name(A,B,C) and the transposed column headers

Hope that helps,

Angelos

example.yxmd

Gavaksh

AngelosPachis for your thought and taking the time to create a workflow for me. But unfortunately this solution may-not work in my case as the column selector ie. Field#4 a evaluates a number of parameters in an excel based on which it spits out the filed name to be selected. For operational reasons that has to remain outside Alteryx.

So in essence, I need a way to tabulate the value only by looking at Field#4 that has the name of the Field from where the data needs to be picked up.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335