1 Reply Latest reply on Oct 19, 2021 4:56 AM by Akanksha Rani

    Dynamic flat file PDO to pick the latest file in IDQ

    Amit B Guru

      Hi All,

       

      I have to build a mapping which loads a file which is generated daily.

      The file format is something like below

      HBA_GB_REF_05102021.txt

      HBA_GB_REF_06102021.txt

      HBA_GB_REF_19102021.txt

       

      There can be multiple files of  different dates and I have to pick the latest file.

       

      All this I can do from a unix script. But, I want to know if there is any easier way to achieve this by creating something like a dynamic flat file PDO?

       

      Thanks!