Hi All, Got this data set and in case of Food want to populate only "Classification 2" field as Non Veg and "Classification 1" should have nothing. Please advise. Type 1Type 2Classification 1Classification 2FruitsVEG Veg Only VeggiesVEG Veg Only FoodVEGNon VegVegNon Veg Thanks in advance

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

Classifying the Data

Hi All,

Got this data set and in case of Food want to populate only "Classification 2" field as Non Veg and "Classification 1" should have nothing. Please advise.

	Type 1	Type 2	Classification 1	Classification 2
Fruits	VEG		Veg Only
Veggies	VEG		Veg Only
Food	VEG	Non Veg	Veg	Non Veg

Thanks in advance

Help

Accepted answers

grazitti_sapna

@AnkurS

Sure.

dataclassification.yxzp

All comments

summarizer

Here is one solution using the Formula tool with two conditional statements. I gave your first column the title "Type" - and you can clean the null downstream later.

AnkurS

Thanks @summarizer for your answer but the problem I have is Values in "Type 1" and "Type 2" are dynamic and what I am after is if both these have data (which is dynamic) then my final data set should only populate Type 1 field and discard Type 2. Please disregard Classification 1 & 2 fields.

Thanks

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703