Table structure

JDong

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

pedrodrfaria

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.