Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Combining 2 Columns to 1 column (non-unique)

Highlighted
7 - Meteor

Hi, I have a quick question on combining 2 columns into 1 row.

 

I have the following dataset:

 

Fiscal YearFinancial Period
Aug-15 
 Oct-15
Aug-15 
Aug-15 Nov-15
 Nov-15

 

As the data is essentially the same in both columns, I want to combine them so that they are all in one column. Also I want the 'Financial Period' column to take priority in the event there is a duplicate in both.

 

Please not that the values are not unique as there could be multiple months/years.

 

Thanks,

Nicholas

Highlighted
11 - Bolide

Hi @nfoong

 

I would use a formula tool to create a new field using the expression below:

 

IIF(

IsNull([Financial Period]),

[Fiscal Year],

[Financial Period]

)

 

2016-12-13_15-48-23.png

 

This is assuming your fields are actually null if blank.

Highlighted
12 - Quasar
12 - Quasar

Another formula option:

 

MAX([Fiscal Year],[Financial Period])
Labels