Hi there, Is it possible to achieve the following transformation in Alteryx? Before: IDValueHeight 116021623170 Weight 112021303140 After IDValueField1160Height2162Height3170Height1120Weight2130Weight3140Weight Thanks, Yiling

Alteryx - how to populate a column with section name?

Hi there,

Is it possible to achieve the following transformation in Alteryx?

Before:

ID	Value
Height
1	160
2	162
3	170


Weight
1	120
2	130
3	140

After

ID	Value	Field
1	160	Height
2	162	Height
3	170	Height
1	120	Weight
2	130	Weight
3	140	Weight

Thanks,

Yiling

Datasets

Accepted answers

acarter881

Yes, I believe this will fix it (see attached).

realign data.yxmd

All comments

acarter881

Hi @yilingchen02

Please see the attached workflow. It can be done with multi-row formulas and a filter tool.

There are likely other methods as well.

Spoiler

realign data.yxmd

robaimes

Hi @yilingchen02

Similar to the previous solution, this can be done with Multi-Row Formula and Filter.

This method is more specific to this data, but variables can be altered in the Multi-Row Formula for whatever data you need to transform.

populate_column_w_section.yxmd

binu_acs

@yilingchen02 One way of doing this

Multi-Row_1018.yxmd

yilingchen02

Thank you all very much. I have several solutions and gets me 95% there. One more challenge: my actual IDs have sth like 1a, 1b, 1c (see below), so when I implement @binuacs's method, these IDs are recognized as 'Field' as opposed to 'ID'. Any way we can address that?

ID	Value
Height
1	160
2	162
3	170
1a	180
1b	190
1c	200




Weight
1	120
2	130
3	140
1a	150
1b	160
1c	170

Thanks,

Yiling

acarter881

Yes, I believe this will fix it (see attached).

realign data.yxmd

yilingchen02

Very neat. Thank you

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703