Classifying the Data

[AnkurS]

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

[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

[summarizer]

Visuals are always helpful. Can you redo your original graphic to show your ideal output?  It sounds like maybe you need some conditional formula still whether in a multi row or a regular formula tool.

[AnkurS]

This is how it has to be:

Input Data Stream

Location	Region A	Region B
TAR	Metro	Regional
WER		Regional
TRU	Metro
PCK	Metro	Regional

Output Data

Location	Region A	Region B	Final Class
TAR	Metro	Regional	Metro
WER		Regional	Regional
TRU	Metro		Metro
PCK	Metro	Regional	Metro

Thanks!

[grazitti_sapna]

Hi @AnkurS ,

Here is the solution to your problem.

Cheers!

[AnkurS]

Thanks @grazitti_sapna 

will it be possible for you attach workflow please 

[grazitti_sapna · Accepted solution]

@AnkurS 

Sure.