Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

Add Values to one field based on the existing field

swapsingh2712
アステロイド

Hello All,

 

I've a data set which looks kinda below

 

Issue_1Issue_2Issue_3Issue_4
aaa gggiii
bbbeee mmm
cccfff  
ddd hhhhkkk

Now I want combine these values under one column only and then remove other columns. So my final data should look like below

Issue_1
aaa
bbb
ccc
ddd
eee
fff
ggg
iii
mmm
kkk

 

Could you please advise how this can be achieved in alteryx?

 

BR

swap

5件の返信5
Felipe_Ribeir0
ネビュラ

Hi @swapsingh2712 

 

One way of doing this

 

Felipe_Ribeir0_1-1675008496438.png

 

 

Qiu
21 - Polaris
21 - Polaris

@swapsingh2712 
Can I confirm why the "hhhh" value is removed in your sample output?

And what happens if there are duplicated values in the input?

flying008
オーロラ

Hi, @swapsingh2712 

 

There is a easy way for you: 

录制_2023_01_30_08_47_18_479.gif

 

******

If it can help you get your want, please mark it as s solution and like for more share.

 

grazitti_sapna
キャスター

@swapsingh2712  Other way of doing it with Transpose tool and filter.

grazitti_sapna_0-1675052167165.png

 

Sapna Gupta
swapsingh2712
アステロイド

Hello All,

 

Thank you so much for your help. I've posted a another questions similar to this one. If you could help. I forgot to add one condition in this scenario

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Add-Rows-based-on-other-columns/m-p/10...

ラベル
トップのソリューション投稿者