Hi All,

 

I am working on Exporting the data into excel.

 

Whenever I tried to export in Excel the name of the column in the excel appeared as the name of the fields that I am using in tables.

For Example : I have two table

Table A:

Fields: Roll, Name, Address

 

Table B:

Fields: Roll, Fee

 

There is relationship between both these tables using fields Roll.

 

Whenever I am exporting the records in Excel from Table B, it gives me column name like

 

Roll, A::Name, A::Address, Fee

 

but it should be in this way,

Roll, Name, Address, Fee

 

or whatever name I should use for column name.

 

Hoping for quick reply ASAP.

 

Thanks in advance.

That's just the way it is.  FM is being "helpful" by showing you the context for the related fields to indicate that it is a different context than the other fields.

 

You could do a post-export cleanup using OS-level script, or dump the data into a scratch table in FM first where you have the proper field names and export from there.

Thanks Wim for your valuable response.

 

I know the second the option. But can you please send me an example for the first option that you have written above. post-export cleanup using OS-level script.

 

Thanks...