Output file with Multiple Condition & format

[vivek1993]

Team,

I have a input file with details of students scoring marks in various subject & in different class. 

I want to create an output file as per the below format where by just submitting student name, marks scored in various subject & class should be updated. Please note that data volume is large & I would like to create output  as per below format also (I.e. Marks as per subject wise)

 Please help me with the workflow for below format & also formula for updating marks for various students as per Subject & class wise.

[atcodedog05]

Hi @vivek1993 ,

Just a pointer merge is not possible be outputted by Alteryx

[atcodedog05]

Hi @vivek1993 ,

Here is a workflow for the task.

Input: file given by you

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Hi @vivek1993 

Here is another format.

Hope this helps 🙂

[vivek1993]

Hi, I would like to apply a formula to obtain marks as per subject & class wise for each student respectively so that results can be updated for any student just my entering the name. E.g. :-

[atcodedog05]

Hi @vivek1993 

Alteryx cannot output excel which had embedded formulas in them.

But a option is you can create an alteryx app where you can give name and subject to get the marks.