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
20 - Arcturus
20 - Arcturus

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

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

Labels