We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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