ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Missing columns in a dataset

Sshasnk
8 - Asteroid

Hi So I have a dataset and this dataset have column which I have to merge but sometime 1 or 2 columns are missing and because of that canvas throws an error 

 

Example: 

Input 1: 

t1t2t3t4
abcd
efgh

 

output 1:

 

t1t2t3t4Output
abcda b c d
efghe f g h

 

Now sometimes the column is missing

 

Input 2:

 

t1
a

 

Output1:

 

t1Output
aa
b

 

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@Sshasnk 
We can use a transpose tool to be more dynamic

0210-Sshasnk-A.PNG0210-Sshasnk-B.PNG

Labels
Top Solution Authors