Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to create an conditional column

PedroRR
5 - Atom

Hi, 

 

I'm new to AlteryX and I need some help with the conditional column function. 

 

In my project, I need to join 3 data sets with the that the same values and columns. The problem is that, each data set refers to a different data base and I need to clearly specify that. To make things clear, for example, data from table X, need to have some specification that the table´s entries refer to table X. Therefore, I thought in adding a conditional column to each table clarifying the data´s origin. It would be something like the table below. 

 

PedroRR_0-1629201241793.png

 


So, I need to add a column with the same entries for all the table data. Does anyone knows how to do that?

 

Thanks for the help and attention.

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @PedroRR 

 

Are you looking for something like this. I am labling using formula tool.

 

Workflow:

atcodedog05_1-1629201978171.png

 

Hope this helps : )

 

PedroRR
5 - Atom

Thanks for the solution, It worked perfectly !

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @PedroRR 

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!

Labels