how to separate a column based on a particular caracteristic

HI , i'm a rookie with Alteryx . I have a file which contains different fields that I need to use in order to build a model that will predict if a student will pass or failed his class early in the semester.

There are 3 periods -1-2-3. (field FK-id-period) . I would like to separated this field in 3 based on that period . ( also the rest of the data would be split based on the period) .

How can I do that in Alteryx and see the 3 different bins? I have attached the file ...or should I send you the alteryx path?

thank you very much !

Catherine

MATH.csv

Preparation

Accepted answers

AkimasaKajitani

Hi @domax37 ,

Are you looking for something like this output?

This is the workflow to do that.

Math_sample_AK.yxzp

All comments

Matthew

Are you looking for something like this where the three periods are split into 3 tables?

PhilipL

@domax37

If you are looking to split the output, you could burst the data into multiple files using an option in the Output Data tool that looks at your period column and makes separate files based on value.

Burst Output.PNG

domax37

Hi ,

Thanks for your reply !

This is what I'm looking for.

This math file contains potential predicators to explain if a student will pass or failed early in the semester. In the field Fk-idperiod , you will find 1-2-3 depending of the exam during the semester.

I need to build a predictive model. (or maybe not , at this point , franckly I just don,t know how to start 😀)

I I would like to create 3 different groups based on the grade for each period (column grade )( at the moment the data for period 1-2-3 are all under one column ) .

I would like to try a try to build a linear regression where my target variable would be grade in period 2 ....where one of my predicators would be grade in period 1 .... So when I build my regression model , I would like to have the capability to choose as a predictor ... grade in period 1 ( not including any data from period 2 or 3)

thank you again for you help!

catherine

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703