nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Combining Data

suby

Hi,

Here i am trying to combine my PROD STATUS and SUB PROD STATUS as one single Column to get the desired Output as attached.

Attached the expected screen shot is my representation in Tableau where the both status Would be combined.

Attached the sample workflow.

Combining Data.yxmd

Combining Data - Alteryx.xlsx

Tableau

Accepted answers

ArtApa

Hi @suby - Here is how you can do this:

CombineDataAA.yxmd

atcodedog05

Hi @suby

My approach would be similar to @ArtApa

Workflow:

Combining Data (1).yxmd

All comments

atcodedog05

Hi @suby

Nice to see you. Expected output snapshot is missing can you please re-provide it.

suby

Apologize missed it.

Input Data - Expected Result.PNG

ArtApa

Hi @suby - Here is how you can do this:

CombineDataAA.yxmd

atcodedog05

Hi @suby

My approach would be similar to @ArtApa

Workflow:

Combining Data (1).yxmd

Quick Links

Unanswered
Community Events
Groups

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703