Dataframe to update subset of fields in table...

[plynton]

I have a table that I'll update with multiple inputs (csv). Is there a simple way to update my target when the source fields won't be a 1:1 match? Another challenge I've run into is that my sources don't have a header field, though I guess I could rename the columns if this would be beneficial.

At this point, I've created a blank dataframe based on a schema and then tried to .copy the source columns into the empty df. However, when I do this I get a warning from DB telling me that this is inefficient.

Any help greatly appreciated.

[Hubert-Dudek · Accepted solution]

Read your CSV as a dataframe and than make update using Merge (upsert).

[Kaniz]

Hi @Peter Ott​ ​, We haven’t heard from you since the last response from @Hubert Dudek​ , and I was checking back to see if you have a resolution yet.

If you have any solution, please share it with the community as it can be helpful to others. Otherwise, we will respond with more details and try to help.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.