Find Consecutive?

[Anonymous]

Hi,

I am trying following:

Can Sombody help?

[petter · Accepted solution]

Here is a solution which shows how it can be done either mostly in the load script with very simple table expressions or entirely done in a table expression in one single example application:

Use this load script for the first table:

Use this load script for the second or third table:

You can find the entire example application attached with the load scripts and tables....

[Anonymous]

Hi Petter,

That is what I wanted thanks a lot for your kind efforts, it will be great if you help me in the same but a bit different scenario actually the month/ID which is mentioned here is repetitive. The format is attached in a excel file here.

[petter]

Thanks, I will see if I can find time later today...

[bvssudhakar]

Hi Petter,

I have one requirement, here i attached one qvw file in that file

If i select for filter 1: Baby Clothes in Category Name, Aino Shoes from Product name, 2012 from Year and

for filter2:Baby Clothes in Category Name, Deuce Shirt from Product name, 2013 from Year

then i want out like this

2422	2/16/2012	Baby Clothes	Aino Shoes	Halle Köln	Bob Park	41
2422	2/16/2012	Baby Clothes	Deuce Shirt	Halle Köln	Bob Park	11
4665	1/21/2013	Baby Clothes	Aino Shoes	La Moda d'il Futuri	Ricardo Gucci	61
4665	1/21/2013	Baby Clothes	Deuce Shirt	La Moda d'il Futuri	Ricardo Gucci	12

But output is not showing like this, it is showing selections related 572 rows some thing

Give some suggestions to out from this situation

Thank you in advance

Sudhakar

[petter]

Hi Sudhakar,

You should post this as a new question yourself - this is a thread that has already been answered.

Best regards

Petter