Two columns as a single list box

[sarasunagaram]

Hi All

Can anyone please help me to achieve the result shown here? These are the two different columns FisacalMonth,Weeknumber.

I wants to have the selection behavior of a list box with the header values..

Thanks in Advance

Muni nagaram

[tresesco]

If you have data like in screen shot above and excel output is your desired output, you may try like:

Corsstable (FiscalMonth, WeekNumber) Load

          1 as dummy,

          *

From <>;

Drop Field dummy;

If it is otherwise, you have to try The Generic Load

[#3]

could you please share ur application ..

[sarasunagaram]

Excel file having original  data but i want to show list box as the screen shot .

Thanks

[tresesco]

Try Like:

GenericLabel:

generic LOAD

     Weeknumber as Key,

     FisacalMonth,

     Weeknumber

FROM [DATA.xlsx](ooxml, embedded labels, table is Sheet1);

CombinedGenericTable:

     load Distinct Weeknumber as Key

from [DATA.xlsx](ooxml, embedded labels, table is Sheet1);

FOR i = NoOfTables()-1 to 0 STEP -1

  LET vTable=TableName($(i));

  IF WildMatch('$(vTable)', 'GenericLabel.*') THEN

  LEFT JOIN ([CombinedGenericTable]) LOAD * RESIDENT [$(vTable)];

  DROP TABLE [$(vTable)];

  ENDIF

NEXT i

[sarasunagaram]

Thanks Tresesco

But how to use these columns as a single listbox.

Thanks

Muni nagaram

[tresesco]

Well lets press 'Refresh' button.   What is your real scenario? Please explain in detail.

[Anonymous]

Hi,

See attached.

Modify to get a field associated with the calendar in your app

Hope this helps!

[sarasunagaram]

Hi Tresesco

I have two fields weeknumber and month name (examole:P01-01,month and weeknumber) i want display two fields in a list box for making selections.

Thanks

Muni nagaram

[tresesco]

May be like this?