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.

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