Generate Week Numbers as Filed during resident load

[agni_gold]

I gave a table , contains Week start date and week end date and other columns ,

But i want to load the resident as week numbers also

1

2

3

4

5

6

7

8

9.........

..

..

..

..

52  as Week field.

How can i do that ....

thanks

[ecolomer]

Probably this one is more clair for you

[agni_gold]

Yes but you are creating saprate table but i need same thing during resident load from source table.

[MarcoWedel]

Please post example data and desired output.

[agni_gold]

How you decided

autogenerate 2190;

2190 value

[agni_gold]

I am attaching excel for data .

excel contains two sheets sorce data and desired output please have a look

[agni_gold]

How you decided

autogenerate 2190;

2190 value

[MarcoWedel]

Hi,

maybe like this?:

LOAD *,
    Week([Month Date]) as Week;
LOAD Date([Month Date], 'MMM') as month,
    Year,
    value,
    Date([Month Date]+IterNo()-1) as [Month Date]
While [Month Date]+IterNo()-1 <= MonthEnd([Month Date]);
LOAD *,
    Date(Date#('1-'&month&'-'&Year)+IterNo()-1) as [Month Date]
FROM [http://community.qlik.com/servlet/JiveServlet/download/598314-122554/Data.xlsx] (ooxml, embedded labels, table is [Sorce Data]);

hope this helps

regards

Marco

[ecolomer]

This is only for tests

[ecolomer]

Is only for tests, and is 2190 = 365 (year) x 6