working in version 2021.4.2. I've seen similar discussions but haven't found one that quite answers my question. I'm trying to add columns to my data by taking values in cells and transposing them over, but I keep hitting walls. Seems easy enough but I can't figure it out. in the below example I want to convert the values in the "Group" column into their own columns. I want to turn this: Employee CodeGroupMarket1AccountingN.America1FinanceN.America1HRN.America1LegalN.America2AccountingEurope2HRN.America3AccountingEurope3FinanceEurope3MfgAsia3HREurope4AccountingAsia5AccountingN.America5FinanceEurope5HRAsia5LegalS.America5MfgS.America into this: Emp IDAccountingFinanceHRLegalMfg1N.AmericaN.AmericaN.AmericaN.America-2Europe-N.America--3EuropeEuropeEurope-Asia4Asia----5N.AmericaEuropeAsiaS.AmericaS.America

Create Columns based on values in Cells

working in version 2021.4.2. I've seen similar discussions but haven't found one that quite answers my question.

I'm trying to add columns to my data by taking values in cells and transposing them over, but I keep hitting walls. Seems easy enough but I can't figure it out.

in the below example I want to convert the values in the "Group" column into their own columns.

I want to turn this:

Employee Code	Group	Market
1	Accounting	N.America
1	Finance	N.America
1	HR	N.America
1	Legal	N.America
2	Accounting	Europe
2	HR	N.America
3	Accounting	Europe
3	Finance	Europe
3	Mfg	Asia
3	HR	Europe
4	Accounting	Asia
5	Accounting	N.America
5	Finance	Europe
5	HR	Asia
5	Legal	S.America
5	Mfg	S.America

into this:

Emp ID	Accounting	Finance	HR	Legal	Mfg
1	N.America	N.America	N.America	N.America	-
2	Europe	-	N.America	-	-
3	Europe	Europe	Europe	-	Asia
4	Asia	-	-	-	-
5	N.America	Europe	Asia	S.America	S.America

Dynamic Processing

Preparation

Accepted answers

binu_acs

@Rob48 Use the Cross Tab tool

All comments

binu_acs

@Rob48 Use the Cross Tab tool

ccanterman

Hi! I got it to work with the Transpose tool (with Sort to get the Employee IDs in the right order). If that doesn't solve it, can you attach your workflow?

Workflow.yxmd

sarahmoe

Hi there,

I understand you're working with Alteryx 2021.4.2 and facing challenges in transposing cell values into new columns. This can indeed be tricky. A potential solution is to use the Cross Tab tool. This tool can pivot your data, turning unique values in the 'Group' column into individual columns.

Here's a quick guide:

Input your data: Ensure your data is correctly inputted into Alteryx.

Select the Cross Tab Tool: Drag and drop the Cross Tab tool into your workflow.
Configure the Tool: In the configuration pane, set 'Group' as the new header field, and choose the appropriate data field (e.g., 'Employee Code') for the new column names.
Run the Workflow: Execute your workflow to see the transformed data.

Remember, the key is to correctly configure the Cross Tab tool to match your data structure. If you encounter any specific issues, feel free to share your workflow or a sample of your data for more tailored advice.

Hope this helps!

sarahmoe

Hi there,

1. Input your data: Ensure your data is correctly inputted into Alteryx.
2. Select the Cross Tab Tool: Drag and drop the Cross Tab tool into your workflow.
3. Configure the Tool: In the configuration pane, set 'Group' as the new header field, and choose the appropriate data field (e.g., 'Employee Code') for the new column names.
4. Run the Workflow: Execute your workflow to see the transformed data.

Hope this helps!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703