1. We get a text file of 2.5 GB size(50 lacs data) ( which shows error if try to open it) so.
2. We split it into chunks.( Eg 10 txt files)
3. These txt file to be converted into Excel sheets( Eg. We split into 10 txt files means 1 file* 5 Lacs rows) 10 files* 5 Lacs =50 Lacs rows with 90 columns.
4. Then we have a template with 90 columns the above file data to be copied into this Excel template.. but columns order may change and name representation may be ( eg 'account name' in excel is as 'acc_name' in template or vice versa)
5. After completion that file has to be uploaded into a website.
1. We get a text file of 2.5 GB size(50 lacs data) ( which shows error if try to open it) so.
2. We split it into chunks.( Eg 10 txt files)
3. These txt file to be converted into Excel sheets( Eg. We split into 10 txt files means 1 file* 5 Lacs rows) 10 files* 5 Lacs =50 Lacs rows with 90 columns.
4. Then we have a template with 90 columns the above file data to be copied into this Excel template.. but columns order may change and name representation may be ( eg 'account name' in excel is as 'acc_name' in template or vice versa)
5. After completion that file has to be uploaded into a website.
Convert text file to Csv then use it as DB it will work under single
An interviewer asks: There are 1, 2, 3 till 10 steps in a process out of which 3,5&7 are the only steps which can be automated. How would you respond to the Client?