New table table1, now has a table a, b, how to put a, b, part of two tables through data window is copied to the table1, and other fields in table1 their entry, and then update the data window save table1, implementation in the PB + oracle, thank you!

CodePudding user response:

Three data window
A table is a data window
B b data are listed in the table window
The table is C data window

A data window according to the condition to extract data
B data window according to the condition to extract data
Then a for loop, add eligible records to the C data window, save C data window

There is another way, in the database to perform the INSERT INTO statement, depending on your table structure

CodePudding user response:

Dw_c. Setitem (dw_c. Getrow (), "colname", dw_1. Getitemstring (dw_1. Getrow (), "colname"))

CodePudding user response:

reference 1st floor ribut9225 response:

three data windowA table is a data window
B b data are listed in the table window
The table is C data window

A data window according to the condition to extract data
B data window according to the condition to extract data
Then a for loop, add eligible records to the C data window, save C data window

There is another way, in the database to perform the INSERT INTO statement, depending on your table structure

Hello, use the insert into how to write, beginners, thank you is written in the query button code inside?