Start Free Trial

Alteryx Designer Desktop Discussions

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

Re: removing null values in columns

utsarunner981
8 - Asteroid

hi everyone! thanks for your help! this is what i am trying to accomplish.

 

dataset1: 

Product ID

name

price 

1001

table

 $ 100.00

1002

sofa

 $ 250.00

1003

chair

 $   40.00

1004

loveseat

 $ 150.00

1005

bed

 $ 300.00

1006

mattress

 $ 100.00

 

dataset2:

Product ID

Date Sold

1001

10/31/2021

1004

11/3/2021

1006

11/1/2021

 

dataset3:

Product IDnameshipping
1001tablecalifornia
1002sofaoklahoma
1003chairtexas
1004loveseatcalifornia
1005bedtexas
1006mattresstexas

 

dataset4:

Product IDnamepriceDate Soldshipping
1001table$10010/31/2021california
1002sofa$250 oklahoma
1003chair$40 texas
1004loveseat$15011/3/2021california
1005bed$300 texas
1006mattress$10011/1/2021texas

 

sample workflow: 

untitled.PNG

1 REPLY 1
ChrisTX
16 - Nebula
16 - Nebula

Would this work for you?  (guessing Dataset 4 is your desired output)

 

ChrisTX_0-1637006355641.png

 

 

Chris

Labels
Top Solution Authors