Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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