topic Re: Save Column Names from a Table into a New Field in QlikView

Save Column Names from a Table into a New Field

Thu, 26 Jun 2014 22:38:42 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!

Gysbert_Wassenaar — Fri, 27 Jun 2014 07:34:06 GMT

You can use the Crosstable function for this:

Crosstable(COLUMN_NAMES, Value)

LOAD * from ...excel_file...;

amit_saini — Fri, 27 Jun 2014 07:41:05 GMT

Hi Mart,

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

Thanks,