How to add a field to existing table?

[durgabhavani]

I have a one table temp with only empid field,

empid

45698

55689

23568

45789

14789

Now i want to add the new field country wtih values to my table temp in my edit script.

Country

uk

japan

india

hong kong

Advice me to write script.

thanks,

Durga

[PrashantSangle]

Hi,

Is there any relation between empid and Country??

REgards

[MK_QSL]

Country:

Mapping Load EmpID, Country From EmployeeTableFile:

Emp:

Load Field1, Field2, Field3, ApplyMap('Country',EmpID,'UnknownCountry') as Country From EmpTableFile;

[durgabhavani]

we have empid in another table but these empid's are different from that one. Also i need to write expression on these empid's. So i dont want disturb these empid's.

So i am planning to add one manual field country and looking to form link with another country in another table.

i think this helps to you.

Thanks,

Durga

[amit_saini]

Hi,

Try:

T1:

Load *,'NewField' As NewField Resident Table;

Thanks,
AS

[durgabhavani]

Hi Manish,

I am not able to get you!

I will give clear picture to you,

I have one table temp (it has only one field empid)

temp:

empid

Now i want to add one country field with values to temp table. (FYI: I have country field in another table details). as below.

temp:

empid,

country

after adding country field i am planning to link temp table to details table.

Hope this helps.

please advice!

Waiting for reply.

Thanks,

Durga

[PrashantSangle]

Hi,

can you explain in detail if possible post your complete script?

It will help us understand your requirement rather than guessing.

Other wise It is difficult to understand what you are trying to do?

Regards,

[durgabhavani]

Hi Max,

I give clear steps in reply to manish, Please find it. definetly it help you to guide me.

Just i want to add one field to existing table.

I have some confedential data in office, so i am not pasting the script.

Thanks,

Durga