Hi,
I m new to webfocus. i hav a req like this

In table
wk month
1 Jan
2 Jan
3 Jan
1 Feb
2 Feb
. ..
and it goes on

My req is to create like this
wk_i month Jan_1 Jan_2 Jan_3 Feb_1 Feb_2...
1 Jan
2 Jan
3 Jan
1 Feb
2 Feb
. ..
Thanks in advance

This message has been edited. Last edited by: <Kathryn Henning>,

Hello,

You can concatenate Month and Week. Hold it using ACROSS will generate new HOLD file with that many columns. Remember to use ASNAMES ON.

Hi Ram,
Thank u for the timely help. i hav done as you said
i got result like this
Jan_1 Jan_2 Jan_3 .....


but i also need the wk_i and month column with that result..
i cant join as i dont hav the common field.
Any idea

Hello,

You should create another HOLD file and then do a CROSS join.

Thanks,
Ram