How to do if x then do something else do nothing?

Hamder83

Hi 

Im trying to generate new rows, if a cell value if not empty.

Fx.: 
Customer - Product - Service
Dennis        Parcel     Special handeling
Mona          Parcel     (null)/empty 

So 

If
!IsEmpty([Serivce]) THEN 
[product] = [service] 
Else (dont generate a row? 
ENDIF 


ive attached a simple workflow showing how im trying to solve it .. 

Tried this too : 
IIF(!IsNull([Service]), "Enviromental-Fee", [Product)

Alteryx if x then something else do nothing.yxmd

Ladarthure

Ok, to do so, you can use a transpose tool which transforms multiple columns in 2 columns and then filter to exclude the null/empty values (find a solution attached!)

Hope it helped!

solution.yxmd