Alteryx - how to populate a column with section name?

[yilingchen02]

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

[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

[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.

[binuacs]

@yilingchen02 One way of doing this

[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 · Accepted solution]

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

[yilingchen02]

Very neat. Thank you