Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

How to get result in Third column keeping text as differentiator

Sanjana_HS
8 - Asteroid

Hi,

 

I want to get result in third column(New Column) Saying if 2022 does not contain same country as 2021 then in New column print that Country name.

Example 1:
In new column I want Russia to flow.

Sanjana_HS_0-1671116297732.png

 

 

Ex 2:
In here i want Thailand to come in new column

 

Sanjana_HS_1-1671116448907.png

 

 

 

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @Sanjana_HS 

 

One way of doing this

 

Felipe_Ribeir0_0-1671118252051.png

 

binuacs
21 - Polaris

@Sanjana_HS One way of doing this

binuacs_0-1671118675343.png

 

Labels