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
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,
Drop Field dummy;
If it is otherwise, you have to try The Generic Load
Weeknumber as Key,
FROM [DATA.xlsx](ooxml, embedded labels, table is Sheet1);
load Distinct Weeknumber as Key
from [DATA.xlsx](ooxml, embedded labels, table is Sheet1);
FOR i = NoOfTables()-1 to 0 STEP -1
IF WildMatch('$(vTable)', 'GenericLabel.*') THEN
LEFT JOIN ([CombinedGenericTable]) LOAD * RESIDENT [$(vTable)];
DROP TABLE [$(vTable)];
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.