Save Column Names from a Table into a New Field

[#1]

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!

[Gysbert_Wassenaar · Accepted solution]

You can use the Crosstable function for this:

Crosstable(COLUMN_NAMES, Value)

LOAD * from ...excel_file...;

[amit_saini]

Hi Mart,

This can be achieved by cross table concept. For more details please see the attachment.

Thanks,

AS