Closed Thread
Results 1 to 10 of 10

Continuous Data Integration From Two Tables into One

  1. #1
    Registered User
    Join Date
    11-20-2021
    Location
    Mp, India
    MS-Off Ver
    2016
    Posts
    17

    Continuous Data Integration From Two Tables into One

    Hello guys first of all thank you for answering my previous question...

    is it possible to merge the data of two tables can be merged into the third table automatically
    as new data is entered in the previous two tables...

    like can we merge the data of Sales and payment table into a third table(having the data of both the tables)

    please advise anything that comes to your mind... anything goes as lom=ng as i can get the results in table3

    please look at the attached file for more reference...

    Once again sorry for bothering you all and thank you for your help
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-20-2021
    Location
    Mp, India
    MS-Off Ver
    2016
    Posts
    17

    Re: Continuous Data Integration From Two Tables into One

    any ideas...

  3. #3
    Registered User
    Join Date
    11-20-2021
    Location
    Mp, India
    MS-Off Ver
    2016
    Posts
    17

    Re: Continuous Data Integration From Two Tables into One

    Any Suggestions

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Continuous Data Integration From Two Tables into One

    Gary,
    Please do not bump threads more than once every 24 hours. We are all volunteers here who have lives beyond this forum. While you may be awake and working, this is a world wide forum and others may be playing, sleeping, working and not have the time to look into your issues. Patience is important here. If you have an urgent issue, you may wish to look at paying for service in the Commercial Services sub forum or hiring a professional consultant in your area. Again, do not bump threads more often than every 24 hours.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Continuous Data Integration From Two Tables into One

    If you are willing to accept this format and use Power Query, then the following can be achieved.

    Excel 2016 (Windows) 32 bit
    J
    K
    L
    M
    N
    O
    P
    1
    Bill
    no.
    Date Party
    Name
    Due Pay Date Received Balance
    2
    444
    4/2/2021
    abc
    273560
    4/12/2021
    273560
    0
    3
    445
    4/4/2021
    bcd
    166050
    4/14/2021
    166050
    0
    4
    446
    4/4/2021
    cde
    169290
    4/14/2021
    169290
    0
    5
    447
    4/5/2021
    def
    138146
    6
    447
    4/5/2021
    abc
    273560
    4/15/2021
    411706
    -138146
    7
    448
    4/7/2021
    bcd
    209993
    4/17/2021
    209993
    0
    8
    449
    4/8/2021
    cde
    164849
    4/18/2021
    164849
    0
    9
    450
    4/9/2021
    def
    145627
    4/19/2021
    145627
    0
    Sheet: Sales + Payment
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-20-2021
    Location
    Mp, India
    MS-Off Ver
    2016
    Posts
    17

    Re: Continuous Data Integration From Two Tables into One

    Sorry... I was being n idiot
    it won't happen again...

  7. #7
    Registered User
    Join Date
    11-20-2021
    Location
    Mp, India
    MS-Off Ver
    2016
    Posts
    17

    Re: Continuous Data Integration From Two Tables into One

    Your answer is awesome but... won't it be a problem with partial payment...
    is there no way to merge the data of two tables... by unique serialization or formula...
    edit:
    Anything thing will do even if it involves changing table structure ... or anything else

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Continuous Data Integration From Two Tables into One

    Partial payments will be reflected with a balance due. Try inputting a partial payment and see your results.

  9. #9
    Registered User
    Join Date
    07-24-2020
    Location
    Madhya Pradesh, India
    MS-Off Ver
    365
    Posts
    61

    Re: Continuous Data Integration From Two Tables into One

    hello sir how can i do it i have the same problem

  10. #10
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Continuous Data Integration From Two Tables into One

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Irregular Data Interval Numerical Integration
    By That Man in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-08-2020, 09:03 PM
  2. Replies: 11
    Last Post: 07-14-2020, 09:31 AM
  3. Creating a continuous graph with non-continuous data
    By Throwaway1234567 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-04-2017, 01:33 PM
  4. Help with data integration
    By yes.fareed in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-30-2014, 07:44 AM
  5. Help with data integration
    By yes.fareed in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2014, 07:05 PM
  6. Help with data integration
    By yes.fareed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2014, 07:04 PM
  7. [SOLVED] Create continuous non blank table based on merge of separate dynamically filled tables
    By escobf in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2013, 04:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1