List box of fields and not values of a field

[saumyashah90]

I have

Header 1	Header 2	Header 3	Header 4
1	2	3	4
5	6	7	8

I want a listbox  like

Header 1
Header2
Header3
Header4

and  also i want it selectable.

[jagan]

Hi,

Use Cross table and tranfor the data.  Check help file for syntax.

Hope this helps you.

Regards,

Jagan.

[saumyashah90]

After many transformation i am creating this format so i dont think that would work

[#4]

try to use CrossTable

syntax

table:

CrossTable(Header1, Value)

LOAD Header1,

    Header2,

    Header3,

     Header4

FROM  table;

[jagan]

Hi,

For this type of tables Cross Table is the apt one.  otherwise you can do like this

Data:

LOAD

     'Header1' AS HeaderNumber,

     Header1 AS HeaderValue

RESIDENT TableName;

LOAD

     'Header2' AS HeaderNumber,

     Header2 AS HeaderValue

RESIDENT TableName;

LOAD

     'Header3' AS HeaderNumber,

     Header3 AS HeaderValue

RESIDENT TableName;

LOAD

     'Header4' AS HeaderNumber,

     Header4 AS HeaderValue

RESIDENT TableName;

Hope this helps you.

Regards,

Jagan.

[saumyashah90]

I am not taking this format as direct input.Otherwise i woulld have loaded it in Crosstable format

I am transforming manytables and geting almost 200 fields.