consolidate files based on group column

[userid128223]

Hi Everyone

I have input excel file with following info.

Course#	Student#
S123	456
P245	334
S123	S545
P245	D345
Z556	5667
S123	S23245
Z556	T0343567

I have script that generates individual files for all student# in .txt format. However my requirement is to create 1 file combined based on by associated Course#.

For example. My script create individual files like below for each student#.

456YYYYMMDD.txt

S545YYYYMMDD.txt

S23245YYYYMMDD.txt

I need to combined the output of each student# based on their course#.

output of above should be combined into 1 file and file named S123.txt

[settu_periasamy]

try to change the field names like below screen shot.

[tamilarasu]

Hello Ami,

My bad. Settu has pointed out my mistake. Let us know If there is any issues.

Hi Settu,

Thanks for correcting me

[userid128223]

Thank you very much Tamil & Settu

[userid128223]

Hi Tamil

One question on your solution.

Let vFileDate = Peek('Temp',0,'Table');

what was the purpose of doing above in the script?

[tamilarasu]

Hello Ami,

Kindly check the word document for understanding.

[tamilarasu]

If you want to generate output files on a daily basis, you should make a small change in the script. Attached is the solution for it.

Kindly check and let me know If you have any questions or clarifications on this.