Forum Stats

  • 3,875,475 Users
  • 2,266,926 Discussions
  • 7,912,227 Comments

Discussions

Apex 18.2 - File Import and finally merge the team files

3473493
3473493 Member Posts: 7
edited Nov 25, 2018 2:28PM in APEX Discussions

Hello Team,

I am planning to work on APEX (beginner) and looking for some information on the requirement. I have different files from team members which contain same data but team will update the status and send it to me for consolidation.  I would like to create Apex web page where they can upload the files and finally I would like to merge or consolidate those files in the tool. I know I can achieve this in excel but data is huge and do not want to followup for files from team members.

If the above requirement possible please just provide me the high level idea to create the options in Apex tool.

Thank you,

Tagged:

Answers

  • fac586
    fac586 Senior Technical Architect Member Posts: 21,478 Red Diamond
    edited Nov 25, 2018 2:28PM
    3473493 wrote:Hello Team, I am planning to work on APEX (beginner) and looking for some information on the requirement. I have different files from team members which contain same data but team will update the status and send it to me for consolidation. I would like to create Apex web page where they can upload the files and finally I would like to merge or consolidate those files in the tool. I know I can achieve this in excel but data is huge and do not want to followup for files from team members.If the above requirement possible please just provide me the high level idea to create the options in Apex tool.

    More information is required:

    • How many files?
    • What format are the files?
    • Is the format of the files always guaranteed to be the same?
    • Is the data in the files guaranteed to be valid?
    • How many columns per file?
    • How many rows per file?
    • What form does the merge process take?
    • What database version and edition is being used?