We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.
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
20 - Arcturus

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
20 - Arcturus

Happy to help : ) @PedroRR 

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

Cheers and have a nice day!

Labels