Regarding Selection

[sarfaraz_sheikh]

Hi All,

I want to extract the data in such way that ..i.e

Suppose i have below below data

Year               Month                  Day

2014-2015      Nov                      1,2,3,4,5,6,7,8,9

Now i want to extract the data till 7 Day.....I do not want 8,9 Day Data in mm Exel file ....How can acheive the same ..

Please help its urgent ...

Sarfaraz

[SergeyMak]

Hi,

It looks like "below data" is not enough.

Only if you need

LOAD

Year,

Month,

LEFT(Day, 13) AS Day1;

Could you give us more data?

Regards,

Sergey

[sarfaraz_sheikh]

Hi ,

As per below image ...I do not want 17 Day related data .. I just want 5 ,7,13 data whenever i will click on Sep .

How i can achive this ...can anybody help

Sarfaraz

[SergeyMak]

Can you share your app and source... I can't catch why you don't need in the first case more then 7 and in the second case you don't need 17...

What is your business requirements?

Regards

Sergey

[#5]

pls explain little bit clear