Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Use Cross table and tranfor the data. Check help file for syntax.
Hope this helps you.
Regards,
Jagan.
After many transformation i am creating this format so i dont think that would work
try to use CrossTable
syntax
table:
CrossTable(Header1, Value)
LOAD Header1,
Header2,
Header3,
Header4
FROM table;
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.
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.