Save Column Names from a Table into a New Field

Thu, 26 Jun 2014 23:58:05 GMT

Hello!

I have an Excel file with a table like this:

ACCT_ID	HR_01	HR_02	HR_03	HR_04	HR_05
001	37	52	26	74	16
002	44	72	34	93	68
003	95	82	43	64	46
004	71	36	97	43	64

What I need, in the script, is to load this table and then save the column names (HR_01, HR_02, HR_03, HR_04, HR_05) in a new field.

So that I would have this new field (COLUMN_NAMES) with the values I mentioned.

Is there any way to do that?

Thank you!

Re: Save Column Names from a Table into a New Field

Fri, 27 Jun 2014 00:44:20 GMT

Try like this.