Exporting Data in Excel

[fmbug]

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.

[Wim Decorte]

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.

[fmbug]

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...