How to import data from future periods only

DaveScott
DaveScott
in Academy Discussions

I want to import data from one model into another, but only for future periods i.e. don't import the historical data. I match on Time but have no way to remove the past periods data from the import selections. Is this possible?

Answers

  • pyrypeura
    pyrypeura

    Hi,

    On your sources saved views you need to filter out historical months.

  • Prajjwal88
    Prajjwal88

    Hi @DaveScott,

    To import data for future periods, create a filter in the source model using a time settings module to mark future months as "true." Apply this filter to the source data module, ensuring the time dimension is in rows along with other dimensions for correct mapping. Save this filtered view and use it as the source for the import, rather than importing directly from the module.

    Hope this helps.

  • DaveScott
    DaveScott

    thanks for the replies - will give it a go!

  • Dikshant
    Dikshant

    Create a filter like this for Future Year.

    image.png
    image.png

  • GersonFeil
    GersonFeil

    @uno online If you have programming skills, you can write a custom script (in Python, R, or any programming language you are familiar with) to read data from the source model, filter the records with future dates, and then write this data to the target model. I hope this helps you.

Categories