Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please attach few rows of your data source in XLS.
It helps to solve your problem faster.
Thanks in advance.
Regards,
Andrei
Hi Andrei,
I have attached the document in the post.
Many Thanks,
Hasvine
Hi Hasvine,
PFA my solution.
Regards,
Andrei
Hi Andrei,
You are a genius. 🙂
Thank you so much. 😄
Kind Regards,
Hasvine
You are welcome!
Regards,
Andrei
Cheers Andrei, Wonderful logic
Thanks
Kiran Kumar
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
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
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