Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Add/Adjust data

I have a "Sales Autoupdate" file which is rewritten every day coming from the ERP System which is the primary source for sales info.

 

Know I want to adjust some data in this file (sales moved from 2023 to 2024) but I cant do it manually in the data since it is updated.

 

What is best practice to solve this? Add a new source with the adjustment and then merge them? How do I merge?

 

 

Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Hi,

    Probably you can do it like you said using two sources and using append option.
    The append option is like UNION so the two tables must have the same structure and there is in this reabon Home-->Append Queries:

     

1 Reply

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    2 years ago

    Hi,

    Probably you can do it like you said using two sources and using append option.
    The append option is like UNION so the two tables must have the same structure and there is in this reabon Home-->Append Queries: