Transforming Data

[ZoeM]

Hi!

I have a data set that I am trying to transform.

In the attached example file, the first three columns will always be the first three columns going forward and will not change. However, the preceding columns could change/more added/names updated/deleted etc as the source may see additional fields added going forward whenever we go through an update.

Ideally, I want all columns after the first three to be summarized into a new column labeled L and S and then added back to the first three accordingly as shown in the Results tab in the file. 

Any ideas?

[IraWatt · Accepted solution]

Hey @ZoeM,

Here is one way to do this:

The crosstab puts all the data into one column to filter on then the select just renames the columns.

This solution uses the transpose Tool which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[ZoeM]

Excellent! It was as simple as that 😋