Template format : Lets assume below is my template. I have all the students details together but is there a way i can drop them all together and it will fill in the existing template? TemplateFeesExpenseBooksUniformStudent 1 Student 2 Student 3 Student 4 Student 5 Student 6 Student 7 1st input file Student 1100153545 2nd input file Student 2100204035 3rd input file Student 6100253050 Output: FeesExpenseBooksUniformStudent 1100153545Student 2100204035Student 3 Student 4 Student 5 Student 6100253050Student 7

How can i do that? Please note that below is my original output. Example is only for 2 students however there are as many as 50 and format of the all 50 files are same. I have managed that put them in the row as below, however that is only for 1 student. How can i keep feeding in the student data and template kept on updating one after another like a loop? Student ASem1Sem2History2533Geography3029English3236Maths4138 Student BSem1Sem2History2533Geography3029English3236Maths4138 sem1 Historysem2 HistorySam1 GeoSam2 GeoSam1 EnglishSam2 EnglishSam1 MathSam2 MathStudent Student A Student B Student C Student D Student E Student F Student G Student H Student I Student J

How to fill values in the template using find and replace

ilovecoding

Template format :

Lets assume below is my template. I have all the students details together but is there a way i can drop them all together and it will fill in the existing template?

Template	Fees	Expense	Books	Uniform
Student 1
Student 2
Student 3
Student 4
Student 5
Student 6
Student 7

1st input file
Student 1	100	15	35	45

2nd input file
Student 2	100	20	40	35

3rd input file
Student 6	100	25	30	50


Output:
	Fees	Expense	Books	Uniform
Student 1	100	15	35	45
Student 2	100	20	40	35
Student 3
Student 4
Student 5
Student 6	100	25	30	50
Student 7

Preparation

Accepted answers

All comments

OTrieger

@ilovecoding

You can add RecordID at the after the template, join the data from the different, union the left side for those students that do not have data and then sort the data based on RecordID, add select tool and then remove the RecordID

MelGibson

Bring your blank template in - join them with the student field - union the join output and the template output then sort student field

template update.jpg

ilovecoding

What if there are 50 students? Can it be done without creating 50 input files at the initial stage?

OTrieger

@ilovecoding

No you do not need 50 inputs. Just use RecordID it will solve the problem.

ilovecoding

How can i do that?

Please note that below is my original output. Example is only for 2 students however there are as many as 50 and format of the all 50 files are same. I have managed that put them in the row as below, however that is only for 1 student. How can i keep feeding in the student data and template kept on updating one after another like a loop?

Student A	Sem1	Sem2
History	25	33
Geography	30	29
English	32	36
Maths	41	38



Student B	Sem1	Sem2
History	25	33
Geography	30	29
English	32	36
Maths	41	38

	sem1 History	sem2 History	Sam1 Geo	Sam2 Geo	Sam1 English	Sam2 English	Sam1 Math	Sam2 Math
Student
Student A
Student B
Student C
Student D
Student E
Student F
Student G
Student H
Student I
Student J

OTrieger

@ilovecoding
With a Batch Macro. Your control parament will be Student. Connect the control parameter tool to filter tool and then you loop your WF for each of the students. Add Macro Output tool and the result will be your full report with the data.

ilovecoding

Hi, can you help attaching the workflow as i never used this function before, simultaneously im exploring this option now

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335