Export One Row like Period Member using EPM Integration Agent

Summary:

Hi Team,

we are working on EPM PBCS integration with OnPrem ERP Staging Tables using EPM Integration Agent.

Our requirement is:

=======================================

PO_Week(Period), Account, Scenario, Version, Data

05/18/2023, 11111, Plan, Working, 100

05/18/2023, 2222, Plan, Working, 200

05/18/2023, 3333, Plan, Working, 300

05/18/2023, 4444, Plan, Working, 400

=====================================

Export of above Data to table is working as expected but requirement is to export only PO_Week.

We used Query method from Data Exchange. Below is query.

INSERT INTO <TABLE> PO_WEEK VALUES(~PO_WEEK~)

Above query inserts 4 Rows in PO_WEEK Column of Table

PO_Week

05/18/2023

05/18/2023

05/18/2023

05/18/2023

---------------

But we need only 1 Row to be inserted. Like below. Is it possible using Data Exchange? Appreciate your inputs.