Forum Discussion

louagej's avatar
louagej
Regular Visitor
8 years ago
Solved

Transfer Query result in data table. Update or Create new row based on the primary key

Hi, I'm using a odata service to load the latest changes from a table based on the SQL Timestamp. We want to avoid that the query is loading each night millions of records. So the result of my Que...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi louagej,

     

    Maybe you can try to use 'Table.InsertRows' function to add custom row.

    Table.InsertRows

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi louagej,

 

Maybe you can try to use 'Table.InsertRows' function to add custom row.

Table.InsertRows

 

Regards,

Xiaoxin Sheng

louagej's avatar
louagej
Regular Visitor
8 years ago

Hi,

 

Table.InsertRows was what I needed.

Thank you!

 

Kind Regards,

Job