community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Combining 2 Columns to 1 column (non-unique)

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
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.

Quasar
Quasar

Another formula option:

 

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