Hi Team,
I have a query that reads data from a database
select name,address,contact,street,pincode,city from Contact
Now I need to insert into a table the below output
Table | Column | Renamed |
Contact | Name | FullName |
Contact | Address | AddressDone |
Contact | Contact | ContactNumber |
Contact | Street | StreetAddress |
Contact | Pincode | Pin |
Contact | City | CityArea |
I need to store the above details from the query in a new database table with the above structure
The Renamed column is the column that is generated in the 'Rename' of select tool.
Thanks
Hi @JDong
Do you need writing that back to the database? You just need to use the Output Data and output it to the database after renaming it with the Select Tool as you mentioned.
With the output data just write it back to the database. See a screenshot below for a configuration of the Output Data if you have any questions.
If you need additional help, can you please be more detailed.
Pedro.