question on how to stack multiple columns into one

Hi,

I have a question of how to quickly stack multiple columns into one

I have a daily task in Alteryx involving a complex dataset. The dataset contains medical diagnoses and diagnostic codes, but it is organized by patient.

I want to transform this data into a simpler format with only two columns:

1. Diagnostic Code
2. Diagnosis

Can you help me with this transformation in Alteryx?

this is my work flow, and also dataset. I split data into two tables, but still I felt it is too redundant, could anyone show me a easier way to do so?

thanks!

how to dynamically stack columns.yxzp

Best Practices

Accepted answers

Raj

@chirimoyayachay
simple way to this
and this will work for n number of columns dynamically

mark done if solved.

1176.yxzp

All comments

Raj

@chirimoyayachay
simple way to this
and this will work for n number of columns dynamically

mark done if solved.

1176.yxzp

Qiu

@chirimoyayachay
A slightly different approach with @Raj .
Anyway, we need to make this dynamic, so the combination of Transpose and Cross Tab is good for multiple-columns issues.

how to dynamically stack columns-r1.yxzp

chirimoyayachay

thank you for your reply, I like this multiple row formula, simple and easy to follow!

chirimoyayachay

thank you for your reply,

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703