Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi , i cant figure that out so maybe you can help me with that .
I have a data set i'm trying to convert into table with crosstable function
I have a product list , every column represent next months. and values inside.
I managed to have good strucutre but i would like to make also a dates for every record on the fly.
I can do that with resident load but maybe there is a better way ? Any ideas ? thanks !
tab:
CrossTable(col1,col2)
load * Inline [
c1,1,2
A,5,6
B,8,9
];
NoConcatenate
LOAD *,AddMonths( Today(),num#(col1)) as Mth Resident tab;
DROP Table tab;
tab:
CrossTable(col1,col2)
load * Inline [
c1,1,2
A,5,6
B,8,9
];
NoConcatenate
LOAD *,AddMonths( Today(),num#(col1)) as Mth Resident tab;
DROP Table tab;