- Posts: 18
- Thank you received: 0
Add New and Update Old Records
12 years 4 months ago #2711
by Greg
Add New and Update Old Records was created by Greg
Hello
For some reason my update is not working.
When I try and update a file with 767 records it updates all the fields with the last record in the file.
Source is text and writer is access table.
Any ideas?
Thanks,
Greg
For some reason my update is not working.
When I try and update a file with 767 records it updates all the fields with the last record in the file.
Source is text and writer is access table.
Any ideas?
Thanks,
Greg
Please Log in or Create an account to join the conversation.
12 years 4 months ago #2712
by admin
Mike
ETL Architect
Replied by admin on topic Re: Add New and Update Old Records
Greg
Have you selected update key?
Page 91 of documentation
Also watch this tutorial
www.dbsoftlab.com/online-tutorials/advan...d-etl-processor.html
Peter
Have you selected update key?
Page 91 of documentation
Also watch this tutorial
www.dbsoftlab.com/online-tutorials/advan...d-etl-processor.html
Peter
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
12 years 4 months ago #2713
by Greg
Replied by Greg on topic Re: Add New and Update Old Records
Thanks for looking at this. This is a great tool and I'm trying to learn how to use it better so I can spread the word.
I want to update three fields, one being a key but not designated a key within the Access table. I don't see a tutorial on this page just two screen shots?
Thanks,
Greg
I want to update three fields, one being a key but not designated a key within the Access table. I don't see a tutorial on this page just two screen shots?
Thanks,
Greg
Please Log in or Create an account to join the conversation.
12 years 4 months ago #2714
by admin
Mike
ETL Architect
Replied by admin on topic Re: Add New and Update Old Records
Greg
You are one click away form the solution
Have a look at attached screen-shot,
Peter
You are one click away form the solution
Have a look at attached screen-shot,
Peter
Mike
ETL Architect
Attachments:
Please Log in or Create an account to join the conversation.