breaking a cell in a table

[#1]

Hello All,

I have a table in this format on SQL:

The Range tab contains the start and end time of each campaign in minutes for each day.

Example:

The first line:

Time	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
Start Time	480	1920	3360	2800	6240	7680
End time	1140	2580	4020	5460	6900	7920

Is there a way whereby I can break it like in the table.

Many Thanks for your help.

Kind Regards,

Hasvine

[crusader_]

Hi,

Please attach few rows of your data source in XLS.

It helps to solve your problem faster.

Thanks in advance.

Regards,

Andrei

[#3]

Hi Andrei,

I have attached the document in the post.

Many Thanks,

Hasvine

[crusader_ · Accepted solution]

Hi Hasvine,

PFA my solution.

Regards,

Andrei

[#5]

Hi Andrei,

You are a genius. 🙂

Thank you so much. 😄

Kind Regards,

Hasvine

[crusader_]

You are welcome!

Regards,

Andrei

[kkkumar82]

Cheers Andrei, Wonderful logic

Thanks

Kiran Kumar

[#8]

Hi Andrei,

Is it possible to only load data between these time only.

Like i have many campaigns and each have there own start time and end time.

I would like to know if its possible to load only these lines which falls in the time frame.

Thanks and Kind Regards,

Hasvine

[crusader_]

Hi Hasvine,

If I understood correctly It possible.

Just add where clause  with your restrictions to you last ( on the top) load statement in preceding load or add new preceding load to avoid calsulations and use field names only.

Hope this helps.

Regards,

Andrei

[#10]

Hi Andrei,

I have attached a my QVW.

Could you please help me load only the data dusing these working hours.

I am really stuck on this calendar.

Thanks,

Hasvine