Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
jordan231
Contributor
Contributor

cross table dynamic date

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. 

jordan231_0-1695370268621.png

 

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 ! 

Labels (1)
1 Solution

Accepted Solutions
anat
Master
Master

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;

View solution in original post

1 Reply
anat
Master
Master

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;