Why Vizioneer?

My photo
Atlanta, Georgia, United States
The "Vizioneer" comes from mashing two words that have shaped my world for most of my adult life - Engineer and [data] Visualizations (or Vizes to those who know what's up). Graduating from first from Oglethorpe University in Atlanta, followed by Georgia Tech with my Bachelors and Masters in Civil Engineering, all of which taught me to think through anything and everything - problem solving, "engineering" solutions, teaching to the "ah ha" moments - is what I love to do. In 2010 that investigative, engineering mindset intersected a job change and a plunge into the world of Data Analysis. In the search for the next great thing I stumbled on to a data visualization and dashboarding product called Tableau software and things just took off. So now I guess you could call me that engineer with the sweet data visualizations - or just "The Vizioneer" :)

In 2013, I joined the incredible team at Slalom, focusing on Tableau and it's been an amazing experience. Recently in 2014, I was honored and humbled to receive Tableau's highest recognition of being named a Tableau Zen Master. Follow along to see what happens next :)

Wednesday, June 18, 2014

Dynamic Parameters - a sorta hack

...And we're back.

It's been a little more than six weeks since I've saddled up and hopped on the blog.  The #Tableau30for30 took a lot out of me and I've needed some time to recover :).

So dynamic parameters.  It's the number one most requested feature idea in the Tableau Community.  Everyone seems to have come across a time where this would come in handy.  It's a great idea and given the demand it should be implemented sooner rather than later.  

Unfortunately, it's not coming in the very soon to be released v8.2.  You'll hear a lot about some very slick new features - Story Points and the Visual Data Window to name a few.  But dynamic parameters ain't on the docket.  So it's time we take matters in to our own hands.

Let's start at the beginning.  What's the point of dynamic parameters?  Here's the text from the idea page (currently with 870 votes - only one with over 320 votes):


Parameters are really useful when you need to do something too complex to be handled by quick filters or action filters. However parameters are currently hobbled by the fact they have to be static lists.

It would be really, really useful and solve a lot of Tableau gotchas, if you could define the options available for a parameter dynamically, from the result of a datasource, and preferably with the option to apply filters also.

That's a bit about what dynamic parameters could do.  Let's talk about what parameters are in general.  Here's what we're NOT talking about - The type of parameter that is a numerical value that can be changed via a slider or typing something in that will affect calculations.  Those parameters work great - no complaints there.  Rather, what the "Idea" is typically talking about is a parameter based on a STATIC list (think one time snapshot) of values of a dimension in the data.  Here's how it typically goes:
Create a new parameter>>Change the data type to "String">>Click the button for a "List" of Allowable values>>Select "Add from Field" and select the dimension to get your list of values (I'm using Superstore data and going with "Category")

































This will create a list of values based on the dimension selected.
















This static list now lives apart from your data set.  If the data set changes (the company adds more product categories) this list will NOT update.  This is the gripe.  The thinking is that if the data changes, so should the parameter.

So here we go.  I'm going to propose an idea.  Follow me for a minute.

When we create a list of values in a parameter, it's as if we're informally creating a new table of values, based on a snapshot of the data, that now lives outside the the data.

What if we just more formally create a table of values that remains based on the underlying data, yet lives outside of the full datasource (as a parameter would).  What if, instead of calling this new table of a single dimension of data a "parameter", we called it what it really is - a small data source.

Here's what I'm proposing - Based on the same example from above (Creating a String Parameter from a List of Values based on the Category field), we head back to the data window and head for the Custom SQL.  What? You don't like SQL?  This is going to be the easiest three lines of code you've ever written.  It goes like this:


























In general terms it's:
Select [Your Dimension]
From [Your Datasource]
Group by [Your Dimension]

And using the SQL from above, what do we get?





























A single value list with all of the Product Categories - this looks strikingly similar to the parameter we created, except for one thing.  This is dynamic.  This list will change if the underlying data would change.

So we've created this dynamic list - what can we do with it?  Basically anything we want - we can do most of the same things we could do with parameters - use it in formulas, use it in quick filters (single select or multi-select - the second option is not currently possible with a parameter), etc....  The sky is the limit.  Here's an example:



































Notice the two data sources.  Superstore is our primary data source and the single value list dynamic table based on Categories is the secondary source.  Creating a multi-select quick filter works like a champ (make sure the two data sources have the correct links and relationships - which Tableau will make sure of if the headers have the same names).





Interesting stuff, I say.

Is it a perfect solution.  Nope - it's a hack.  Are there a dozen reasons why it's not a best practice? I'm sure there are, and I'm sure the comments section below will let that play out.  But with all that said - could it help solve a problem you're having? It just might.  

It's a crazy simple solution and my hope is that it sparks a conversation.  I by no means think this is anywhere near the last word on this topic, but with v8.2 walking out the door, it's time we begin to amass ideas for v9.0.

I look forward to your feedback.  Many thanks- 

Nelson

91 comments:

  1. This is a great hack - I've been using a combination of sets and filters to get what I need, but this may be easier - I could set up different views in SQL depending on the "filter" I want and link them as a "data sources" listing my dimensions I need.

    ReplyDelete
    Replies
    1. Thanks Stacey - I do hope it's helpful. I know there are some weak points in the solution, but I also think there may be some cases where this could really help. Keep me posted on how it goes when you implement this! Thanks!

      Delete
    2. Thanks Nelson! This looks promising.

      Hi Stacey any chance you can share your version of usage by combining sets and filters?

      Thanks!

      Delete
    3. Greetings to every one that is reading this testimony. I have been rejected by my husband after three(3) years of marriage just because another woman had a spell on him and he left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address gbojiespiritualtemple@gmail.com , have help a woman to get back her husband and i gave him a reply to his address and he told me that a woman had a spell on my husband and he told me that he will help me and after 2 days that i will have my husband back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my husband. Thanks for Dr,gbojie . His email: gbojiespiritualtemple@gmail.com OR.His WhatsApp Number:+2349066410185 or check out his website:https://gbojiespelltemple.wordpress.com

      Delete
    4. Hello am From Canada. I feel so joyful today because of the help Dr Abaka has rendered to me for getting my Husband back with his spell. I have been married for 3 years and it has been so terrible because my husband was cheating on me and was seeking for a divorce. But when i came across Dr Abaka Email, on the internet posted by a lady, i decided to get in touch with him and i explained my situation to him and then seek his help but to my greatest surprise he told me that he will help me with my case for there is no problem without a solution. Here i am celebrating because my Husband is back home and am really enjoying my marriage, what a great celebration. i will keep on testifying on the internet because Dr Abaka is truly a real spell caster. Why not contact Dr Abaka now if you are facing any challenges in your relationship life. Email drabakaspelltemple@gmail.com website https://drabakaspelltemple.blogspot.com or call/whats app +2349063230051

      Delete
    5. i am ERIC BRUNT by name. Greetings to every one that is reading this testimony. I have been rejected by my wife after three(3) years of marriage just because another Man had a spell on her and she left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address AKHERETEMPLE@gmail.com have help a woman to get back her husband and i gave him a reply to his address and he told me that a man had a spell on my wife and he told me that he will help me and after 3 days that i will have my wife back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my wife. Thanks for helping me Dr Akhere contact him on email: AKHERETEMPLE@gmail.com
      or
      call/whatsapp:+2349057261346










      i am ERIC BRUNT by name. Greetings to every one that is reading this testimony. I have been rejected by my wife after three(3) years of marriage just because another Man had a spell on her and she left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address AKHERETEMPLE@gmail.com have help a woman to get back her husband and i gave him a reply to his address and he told me that a man had a spell on my wife and he told me that he will help me and after 3 days that i will have my wife back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my wife. Thanks for helping me Dr Akhere contact him on email: AKHERETEMPLE@gmail.com
      or
      call/whatsapp:+2349057261346

      Delete
    6. Am jeremiah, I am testifying about a great hebal man that cured my wife of hepatitis B, and liver cirhosis. his name is Dr oniha. My wife was diagnose of hepatities two years ago, i almost spent all i had then, until i saw dr oniha recommendation online, and i call him, then he told me how to get the herb. You can also call him on +2347089275769 or email him at dronihaspell@yahoo.com

      Delete


    7. Am jeremiah, I am testifying about a great hebal man that cured my wife of hepatitis B and liver cirhosis. his name is Dr oniha. My wife was diagnose of hepatities two years ago, i almost spent all i had then, until i saw dr oniha recommendation online, and i call him, then he told me how to get the herb. You can call him on +2347089275769 or email him at dronihaspell@yahoo.com

      Delete
    8. Greetings to every one that is reading this testimony. I had been rejected by my husband after five(5) years of marriage just because another woman had cast a spell on him and he left me with 2 kids to suffer. One day when i was reading through the web, i saw a post on how he help a woman to get back her husband and i gave him a chance he told me that my husband is under spell, he said that he will help me and after 7 days that i will have my husband back. i believed he and today i am glad to let you all know that this spell caster has the power to bring lovers back now my husband is back with after 7 days . he also gave me a financial magic ring to boost my business and removed bad luck. i am now happy with my husband. Thanks you Dr. love please contact him at (lovespelldoctor0@gmail. com)

      Delete


    9. BEST SPELL CASTER WHO CAN HELP YOU WITH LOVE-SPELL TO GET YOUR EX LOVER BACK URGENTLY AFTER BREAKUP/DIVORCE EVEN IF YOUR SITUATION SEEMS HOPELESS! CONTACT: DOCTOR0LOVESPELL@GMAIL.COM IS CERTAINLY THE BEST SPELL CASTER ONLINE AND HIS RESULT IS 100% GUARANTEE..  
      Today being the most happiest day of my life after 1 year of sadness and sorrow without being with the one i love so much, i tried all my possible best to make sure i make my lover happy but it never seems to work out well it was like am doing everything in vain but all thanks to Dr love0 for coming to change all my worries and sadness to Joy. i knew the great man when i read some wonderful reviews about Dr love0 how he has helped a lots of people on there relationship problem i was reading a magazine which then i saw great testimonies as well which then i decided not to waste time because i have missed my lover so much i decided to contact him and share all my problem with him which then he told me not to worry that he assures me that within 48 hours everything would be sorted out i believed Dr love0 so much because i believe he can’t fail me but truly Dr love0 never failed me cos a man that stand on his worlds is really a man,my husband who left me for a year plus replied my text and for the first time returned my calls and asked me to please forgive him i was so happy and so grateful to Dr love0 for what he has done for me. if you are there passing through this same problem or of any kinds just contact this great man on email:( doctor0lovespell@gmail.com ) check his blogs: https://doctorlovespell0.blogspot.com/  or check website:  https://doctor0lovespell.wixsite.com/lovespell or visit his FB page: https://www.facebook.com/Love-Spell-Doctor0-107453264273672/

















      BEST SPELL CASTER WHO CAN HELP YOU WITH LOVE-SPELL TO GET YOUR EX LOVER BACK URGENTLY AFTER BREAKUP/DIVORCE EVEN IF YOUR SITUATION SEEMS HOPELESS! CONTACT: DOCTOR0LOVESPELL@GMAIL.COM IS CERTAINLY THE BEST SPELL CASTER ONLINE AND HIS RESULT IS 100% GUARANTEE..  
      Today being the most happiest day of my life after 1 year of sadness and sorrow without being with the one i love so much, i tried all my possible best to make sure i make my lover happy but it never seems to work out well it was like am doing everything in vain but all thanks to Dr love0 for coming to change all my worries and sadness to Joy. i knew the great man when i read some wonderful reviews about Dr love0 how he has helped a lots of people on there relationship problem i was reading a magazine which then i saw great testimonies as well which then i decided not to waste time because i have missed my lover so much i decided to contact him and share all my problem with him which then he told me not to worry that he assures me that within 48 hours everything would be sorted out i believed Dr love0 so much because i believe he can’t fail me but truly Dr love0 never failed me cos a man that stand on his worlds is really a man,my husband who left me for a year plus replied my text and for the first time returned my calls and asked me to please forgive him i was so happy and so grateful to Dr love0 for what he has done for me. if you are there passing through this same problem or of any kinds just contact this great man on email:( doctor0lovespell@gmail.com ) check his blogs: https://doctorlovespell0.blogspot.com/  or check website:  https://doctor0lovespell.wixsite.com/lovespell or visit his FB page: https://www.facebook.com/Love-Spell-Doctor0-107453264273672/
















      Delete
    10. I want to thank Dr Emu a very powerful spell caster who help me to bring my husband back to me, few month ago i have a serious problem with my husband, to the extend that he left the house, and he started dating another woman and he stayed with the woman, i tried all i can to bring him back, but all my effort was useless until the day my friend came to my house and i told her every thing that had happened between me and my husband, then she told me of a powerful spell caster who help her when she was in the same problem I then contact Dr Emu and told him every thing and he told me not to worry my self again that my husband will come back to me after he has cast a spell on him, i thought it was a joke, after he had finish casting the spell, he told me that he had just finish casting the spell, to my greatest surprise within 48 hours, my husband really came back begging me to forgive him, if you need his help you can contact him with via email: Emutemple@gmail.com or add him up on his whatsapp +2347012841542 is willing to help any body that need his help.
      For more details about Dr Emu visit his Website: http://emutemple.website2.me/

      Delete
    11. REAL URGENT EFFECTIVE SPELL CASTER TO HELP BRING BACK EX LOVER AND SAVE MARRIAGE https://doctor0lovespell.wixsite.com/mysite-2
      I want to let the world know about Dr Love0 the Great spell caster that brought back my husband to me when i thought all hope was lost. Dr Love0 used his powerful spell to put a smile on my face by bringing back my man with his spell, at first i thought i was dreaming when my husband came back to me on his knees begging me to forgive him and accept him back and ever since then he loves me more than i ever expected so i made a vow to my self that i will let the World know about Dr Love0 because he is a God on earth. Do you have problems in your relationship ? have your partner broke up with you and you still love and want him back ? Do you have problem with your finance ? or do you need help of any kind then contact Dr Love0 today for i give you 100% guarantee that he will help you just as he helped me. Dr Love0 email:(doctor0lovespell@gmail. com) or visit his website: https://doctor0lovespell.wixsite.com/mysite-2  or contact his FB page: https://www.facebook.com/Lovespellthatworkfastusa  also check his blogs: https://doctorlovespell0.blogspot.com/

      Delete
    12. Divorce and marital breakthrough save your marriage / relationship from breakup and Divorce? you can contact Dr. Raypower through email Urgentspellcast@gmail.com or call him directly or WhatsApp on +1 (424) 330-8109

      Good day everybody, My names are Alicia Leonard i am out here to spread this good news to the entire world on how I got my ex husband back. It all started when my husband cheated on me with another woman unknowing to him that the woman is a wizard, the woman castes a spell on my husband which made my husband change his feelings towards me and the kids and broke our 6 years marriage. I was confused and stressed because of the pains of being a single mother, so i called a friend and explained my marital challenges to her, she instructed and directed me to contact this great powerful spell caster called Dr. Raypower, The main reason why she instructed me to contact Dr Raypower was because in recent times she have read some testimonies on the internet which some people has written about the powerful spell caster Dr Raypower and i was so pleased and i decided to seek for assistance from him which he did a perfect job by casting a spell on my husband and utilize the powers of the other woman which made him to come back to me and beg for forgiveness. I will not stop publishing his name on the net because of the good work he is doing. To everyone with marital problem, divorce issues, lost lover or any relationship related issues, you can contact Dr. Raypower the powerful urgent spell caster via details below 
      Email: Urgentspellcast@yahoo.com or Urgentspellcast@gmail.com  
      Website: https://urgentspellcast.wordpress.com/  and   http://urgentspellcast.website2.me/
      Blog: https://drraypower.blogspot.com/  
      Call/WhatsApp: +1 (424) 330-8109

      Delete
    13. I want to quickly crave your indulgence and bring to your notice a powerful spell caster called Dr LOVE0 who in just 3 days of contact was able to bring back my lost love am short of words to thank him and i have resort to this medium of telling the world at large about him. His truly amazing and kind contact him today via Email: doctor0lovespell@gmail.com or check his blogs: https://doctorlovespell0.blogspot.com/ or visit his FB page: https://www.facebook.com/Lovespellthatworkfastusa  .He is also able to cast spells like
      1:Pregnancy Spell
      2:Jail Release
      3:Prosperity Spell
      4:Lottery Spell
      5:Cancer cure ETC......












      I want to quickly crave your indulgence and bring to your notice a powerful spell caster called Dr LOVE0 who in just 3 days of contact was able to bring back my lost love am short of words to thank him and i have resort to this medium of telling the world at large about him. His truly amazing and kind contact him today via Email: doctor0lovespell@gmail.com or check his blogs: https://doctorlovespell0.blogspot.com/ or visit his FB page: https://www.facebook.com/Lovespellthatworkfastusa  .He is also able to cast spells like
      1:Pregnancy Spell
      2:Jail Release
      3:Prosperity Spell
      4:Lottery Spell
      5:Cancer cure ETC......









      I want to quickly crave your indulgence and bring to your notice a powerful spell caster called Dr LOVE0 who in just 3 days of contact was able to bring back my lost love am short of words to thank him and i have resort to this medium of telling the world at large about him. His truly amazing and kind contact him today via Email: doctor0lovespell@gmail.com or check his blogs: https://doctorlovespell0.blogspot.com/ or visit his FB page: https://www.facebook.com/Lovespellthatworkfastusa  .He is also able to cast spells like
      1:Pregnancy Spell
      2:Jail Release
      3:Prosperity Spell
      4:Lottery Spell
      5:Cancer cure ETC......


      Delete
    14. My name is sharon smith, i live in UK. My life is back!!! After 2 years of Broken marriage, my husband left me with two kids, I felt like ending it all.I came across several testimonies about this particular spell caster. Some people testified that he brought their Ex lover back, some testified that he restores womb,cure cancer,and other sickness, some testified that he can cast a spell to stop divorce and also spell to get a good paid job so on. He is amazing, i also came across one particular testimony, it was about a woman called Vera, she testified about how he brought back her Ex lover in less than 24 hours, and at the end of her testimony she dropped his email.After reading all these, I decided to give it a try. I contacted him via email and explained my problem to him. In just 24hours, my husband came back to me. We resolved our issues, and we are even happier than ever. DR LOVE0 you are a gifted man and i will not stop publishing him because he is a wonderful man. If you have a problem and you are looking for a real and genuine spell caster, Try him anytime, he is the answer to your problems. you can contact him through his email: (doctor0lovespell@gmail.com) or contact his FB page:https://www.facebook.com/Lovespellthatworkfastusa or visit his website: https://doctor0lovespell.wixsite.com/mysite-2 or check blogs: https://doctorlovespell0.blogspot.com/

      Delete
  2. Hey Nelson, some great thinking here around the problem, nice to get the ball rolling on how to solve for dynamic parameters.

    There are some use cases where the above does not currently work, for example if I want to use a calculated field like IF [Category]=[source2.product category] THEN [Category] ELSE 'Other' END and place that on the rows shelf or the color shelf it does not work. This is because a blend is required to get the viz, but that blend also means that any filters on the secondary source will also apply to the primary. So in a sense it becomes a quick filter rather than a parameter.

    Its so close, all that's missing is the ability for Tableau to utilize two unblended data sources in a single calculated field......

    ReplyDelete
    Replies
    1. Peter -
      Thanks for the feedback and you're right - because we end up using this as a quick filter you lose the ability to show an "Other". I've tried about 7 ways to Sunday using sets and combined sets to get around it, but to no avail at the moment. It's close, and I think it's fun to have ideas to talk about to kick the can down the road. Keep me posted if you come up with anything fun on this. Many thanks for checking it out.

      Nelson

      Delete
  3. PeterG - See http://drawingwithnumbers.artisart.org/creating-a-dynamic-parameter-with-a-tableau-data-blend/ for how to get something like what you want. You can turn off the Category as a linking dimension in the secondary source, in which case a filter on the Category in the secondary only filters the secondary and not the primary (and vice versa). However, to have the match work right for a [Category] vs. Other then the Category (or a field with finer granularity than Category) has to be in the view as a dimension (since all calculated fields using dimensions or measures from the secondary have to be aggregated, the view has to have fine enough granularity so the comparison will work), in which case to make an Selected vs. Other value you'd need a table calculation to aggregate over all the Categories. You can see an example of that in http://drawingwithnumbers.artisart.org/selecting-one-to-see-one-vs-all-other/.

    There are also ways to use Sets from secondary sources, see http://drawingwithnumbers.artisart.org/how-to-have-sets-with-your-secondary-data-sources/ for details. However, selecting the particular value of a dimension to use for the IN/OUT of a set from the secondary is just like for the primary, there's no real dynamic way to do that outside of Tableau desktop, unfortunately.

    Nelson: I'm glad to see someone else posting this idea, I've been exploring various funky use cases for data blending for awhile now and there are some very cool things we can do with it!

    Jonathan

    ReplyDelete
  4. Thanks Jonathan, using your data blend technique and Nelsons post I've been able to get most of the way there. As you state though I need Category in the view for it to work. I've tried using variations on window_sum calcs to get the aggregation but its not behaving like it would with a single source because the new field I create for 'selected vs other' can't be used for the partitioning (because under measures)

    I also tried the technique in your second blog post but it seems to be dependent on having another blend (i.e. on date), is that correct?

    This is certainly a brain tax!

    ReplyDelete
  5. Is it possible to insert these "parameters" into text?

    ReplyDelete
  6. Hi Nelson
    I am able achieve the above mentioned trick to filter different (Data Source) worksheets on a single dashboard, but when I follow the same for multiple Dashboards is it possible to achieve parameter action with the quick filter when all my data sources for each dashboard are blended together by a common field ?

    Thanks
    Praveen

    ReplyDelete


  7. very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.



    Nexus 5 Case

    ReplyDelete
  8. Get SAP Successfactors Online Training by Certified consultant from India. Enroll for Expert level Instructor Led Online SAP SuccessFactors Training. Apply today!

    ReplyDelete
  9. W3 D Technologies is a pioneer in Dell Boomi Training sector, providing the Dell Boomi Online Training course we have experienced expert faculty for Dell Boomi http://goo.gl/Rt7DuX

    ReplyDelete
  10. We are offering Dell Boomi Online Training with latest techniques. Our experts have more than 8 years experienced and certified. Dell Boomi Online Training

    ReplyDelete
  11. Nice Blog, thanks for the article. For tutorials, interview questions and online training on Dell Boomi Visit TekSlate.

    ReplyDelete
  12. Nice post....We provide the cool gadgets....For more detail about cool gadgets click here Cool Gadgets | Electronics Gadgets | Latest Technology

    ReplyDelete
  13. Useful information...... We provide gadgets at reasonable price....For more detail visit here Cool Gadgets | Electronics Gadgets | Latest Technology

    ReplyDelete
  14. Nice post.....We provide the guideline for educational purpose.....visit here Ehow-india | How to Guides India | Ehow-India How To India Guides

    ReplyDelete
  15. Hi there, awesome site. I thought the topics you posted on were very interesting.
    Buy iPhone 4s Back Cover in India.

    ReplyDelete
  16. Replies
    1. Hello everyone i am charlotte cora by name.I was diagnosed with HERPES for close to a year and 4 years my friend Cindy introduced me to Dr Abaka that i can be cured by him which I never believed because I have spend so much money on different doctors. She advised that i give it a try because he cured her of Cancer with natural herbs. So I mailed him and complain to him about my illness, he said to me I am in the right place. Today i am the most happy person on Earth all thanks to Dr Abaka, he cured me with his herbal medicine. All i did was to order for the herbs which he sent through courier delivery services and he instructed me on how to apply it for a period of 2 weeks, before the completion of the 2nd week i was totally cured .I'm so happy thank you Dr Abaka. I share this because of the pain i passed through when i had it and i care about those passing through the same pain. He also said he has herbs for all kind of illness including HIV/AIDS, ASTHMA, CANCER, DIABETIC 1&2, BARRENNESS, IMPOTENCE, WOMB DAMAGE, HIGH BLOOD PRESSURE and EPILEPSY, Email him now on drabakaspelltemple@gmail.com or call him on +2349063230051.Thank you doctor i will keep on telling the world about you because i am free of genital herpes forever.

      Delete
  17. How do we do if we have to set the parameter dynamically in production for multiple data sources. does tableau support this.

    ReplyDelete
  18. Hello,
    Thanks for sharing this solution. I had never thought of using SQL to create a single value data-source, and I can see a lot of possiblities for how this could help me with other situations. However, in this case I need to add the parameter to a stored SQL procedure. Your solution changes the data-type from a parameter to a filter. I need the data-type to remain 'parameter' so I can add it to a stored procedure, and it would be nice if I could make the parameter within the procedure dynamically update based on the data-source.

    ReplyDelete
  19. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.

    Tableau online training hyderabad

    ReplyDelete
  20. After being in relationship with Wilson for seven years,he broke up with me, I did everything possible to bring him back but all was in vain, I wanted him back so much because of the love I have for him, I begged him with everything, I made promises but he refused. I explained my problem to someone online and she suggested that I should contact a spell caster that could help me cast a spell to bring him back but I am the type that don't believed in spell, I had no choice than to try it, I meant a spell caster called Dr Zuma zuk and I email him, and he told me there was no problem that everything will be okay before three days, that my ex will return to me before three days, he cast the spell and surprisingly in the second day, it was around 4pm. My ex called me, I was so surprised, I answered the call and all he said was that he was so sorry for everything that happened, that he wanted me to return to him, that he loves me so much. I was so happy and went to him, that was how we started living together happily again. Since then, I have made promise that anybody I know that have a relationship problem, I would be of help to such person by referring him or her to the only real and powerful spell caster who helped me with my own problem and who is different from all the fake ones out there. Anybody could need the help of the spell caster, his email: spiritualherbalisthealing@gmail.com or call him +2349055637784 you can email him if you need his assistance in your relationship or anything. CONTACT HIM NOW FOR SOLUTION TO ALL YOUR PROBLEMS

    ReplyDelete
  21. CIITN is located in Prime location in Noida having best connectivity via all modes of public transport. CIITN offer both weekend and weekdays courses to facilitate Hadoop aspirants. Among all Hadoop Training Institute in Noida , CIITN's Big Data and Hadoop Certification course is designed to prepare you to match all required knowledge for real time job assignment in the Big Data world with top level companies. CIITN puts more focus in project based training and facilitated with Hadoop 2.7 with Cloud Lab—a cloud-based Hadoop environment lab setup for hands-on experience.

    CIITNOIDA is the good choice for Big Data Hadoop Training in NOIDA in the final year. I have also completed my summer training from here. It provides high quality Hadoop training with Live projects. The best thing about CIITNOIDA is its experienced trainers and updated course content. They even provide you placement guidance and have their own development cell. You can attend their free demo class and then decide.

    Hadoop Training in Noida
    Big Data Hadoop Training in Noida

    ReplyDelete

  22. Great presentation of Tableau form of blog and Tableau tutorial. Very helpful for beginners like us to understand Tableau course. if you're interested to have an insight on Tableau training do watch this amazing tutorial.
    https://www.youtube.com/watch?v=AgPjawkX7Mg

    ReplyDelete
  23. My testimony on how i won £4,000,000 with the great help of Dr Davi powerful lottery spell: Call him +55 (11) 97732-4658   
    It's unbelievable how fortunate I feel after finding your website. For the past 14 years, I have been looking for a way on how i will win lottery. Money situation was one of the biggest problem to me. I had a huge amount of debt and I didn't know what to do. Out of complete and total desperation, I contacted many of those so-called individuals who promised powerful magic to win the lottery, witchcraft or black magic. None of them worked and none were as wonderful, affectionate and warm as Dr Davi has been. He is definitely different from the others and I felt immediate hope and strength from hearing about the promises he had to offer. He carries an air of purity and divine strength that is as pure as fresh snow on the ground. I requested Dr Davi most powerful spells and I was relieved right away that I had someone to solve my problems for me. His spells worked wonders,i won (Four Million pounds) my money troubles resolved itself after winning the lottery. My life change over night,i now have my own house and two cars,also i am free from my debts. Dr Davi, I have no idea what I would have done without you being there to help me out. If you are there and you need a powerful magic to win the lottery,Dr. Davi is the right person you need to trust and work with,i promise you that you will also win and share your own testimony. You can contact him via email:

    Spelltemple@fastmail.com Call or text him +55 (11) 97732-4658 

    ReplyDelete
  24. Greetings to every one that is reading this testimony. I have been rejected by my husband after three(3) years of marriage just because another woman had a spell on him and he left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address gbojiespiritualtemple@gmail.com , have help a woman to get back her husband and i gave him a reply to his address and he told me that a woman had a spell on my husband and he told me that he will help me and after 2 days that i will have my husband back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my husband. Thanks for Dr,gbojie . His email: gbojiespiritualtemple@gmail.com OR.His WhatsApp Number:+2349066410185 or check out his website:https://gbojiespelltemple.wordpress.com

    ReplyDelete
  25. It's A Great Pleasure reading your Article, learned a lot of new things, we have to keep on updating it learn Mulesoft online Thanks for posting.

    ReplyDelete
  26. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.

    Dell boomi Free demo

    ReplyDelete
  27. Greetings to you all, i am here today on this forum giving a life testimony on how Dr Idahosa has cured me from Hiv Virus, i have been stocked in bondage with this virus for almost 2years now, i have tried different means to get this sickness out of my body i also heard there was no cure to the virus, all the possible ways i tried did not work out for me, i do have the faith that i was going to be cured one day, as i was a strong believer in God and also in miracles, One day as i was on the internet i came across some amazing testimonies concerning how Dr Idahosa has cured different people from various sickness with his Herbal Herbs Medicine, they all advised we contact Dr Idahosa for any problem, with that i had the courage and i contacted Dr Idahosa i told him about my Sickness, He told me not to worry that he was going to prepare some Herbal Medicine for me, after some time in communication with Dr Idahosa, he finally prepared for me some herbs which he sent to me and he also gave me prescriptions on how to take them, My good friends after taking Dr Idahosa Herbs for some weeks i started to experience changes in me and from there, I noticed my Hiv Virus was no longer in my body, as i have also gone for test, Today i am fit and healthy to live life again, I am so happy for the good work of Dr Idahosa in my life, Friends if you are having any types of disease problem kindly email Dr Idahosa on { dridahosasolutioncenter@gmail.com} or call his WhatsApp number on +2348134261542 God Bless you Sir.

    ReplyDelete
  28. nice article thanks for shaaring
    http://www.kitsonlinetrainings.com/sap-abap-on-hana-online-training.html
    http://www.kitsonlinetrainings.com/sap-grc-online-training.html
    http://www.kitsonlinetrainings.com/sap-mm-online-training.html
    http://www.kitsonlinetrainings.com/sap-security-online-training.html

    ReplyDelete
  29. A GREAT SPELL CASTER (DR.TAKUTA) THAT HELP
    ME GET MY EX HUSBAND BACK, AM SO HAPPY
    My name is LUCY SETHI from USA .I am here to
    give testimony on how I got my husband back.
    My husband left me for no reason 3 years ago.
    He moved in with another woman, I felt like
    killing myself, my life became very bitter and
    sorrowful. Then 1 day, a friend of mine told me
    about a great spell caster that is very good and,
    he said he gave him some lucky numbers that he
    played in a lottery and he won. I didn't believe it
    because I've worked with so many of them and it
    didn't work. He begged me further so I decided
    to try this great spell caster called DR TAKUTA. I
    still didn't believe. I used the spell he gave me
    and the next day I received a call from my
    darling husband Thomas last month. He
    apologized and came back to me. He even gave
    me 10,000USD as a means of compensating me.
    I'm very happy now. please i will advise you to contact him
    now and see for your self his Email is via____
    takutaspellalter@gmail.com or whatsapp him
    through the following contact on +27788634102


    Dr.TAKUTA also cures:
    1. HEPATITIS A,B,C
    2. HERPES 1/2
    3.DIABETES
    4.STROKE.
    5.HIV/AIDS HERBAL CURE, STDS and STI
    6. MARRIAGE COUNSELLING
    7.LOVE SPELL CASTING
    8.JOB PROMOTION SPELLS
    9.MARITAL PROBLEM
    10.MAGIC MONEY SPELLS

    ReplyDelete
  30. THANKS TO DOCTOR OSAZE WHO HELP ME BRING MY EX WIFE BACK AFTER FIVE YEARS, MY WIFE LEFT ME FOR ANOTHER MAN BECAUSE OF A VERY SLIGHT QUARREL.
    I TRIED ALL MY POSSIBLE BEST TO RESOLVE THE ISSUE, BUT MY WIFE WAS HAVING A BAD ADVICERS TELLING HER NOT TO EVER RETURN TO ME,UNTIL I CAME ACCROSE WITH DR OSAZE'S TESTIMONIES AND RECOMMENDATIONS ONLINE, ON HOW HE HAS HELPED PEOPLE BRING THEIR EX LOVERS BACK, AND I DECIDED TO TELL HIM MY SAD LOVE STORY, AND HE ASK ME TO DO CERTAIN INCANTATION AND WITHIN SEVEN DAYS, MY WIFE RAN BACK TO ME, AFTER DOCTOR OSAZE PERFORM HIS MAGICAL SPELL.
    IN CASE YOU ARE PASSING THROUGH SIMILAR PROBLEM, AND YOU NEED DR OSAZE ASSISTANCE, YOU CAN CALL OR WHATSAP HIM ON +2347089275769 OR +18565020158 EMAIL DROSAZE39@GMAIL.COM

    ReplyDelete
  31. This is a testimony that i will tell to every one to hear. i have been married four 5years and on the fifth year of my marriage, another man had a spell to take my lover away from me and my wife left me and the kids and we have suffered for 3years until i meant a post where this man Dr,winner have helped someone and i decided to give him a try to help me bring my love wife home and believe me i just send my picture to him and that of my wife and after 45hours as he have told me, i saw a car drove into the house and behold it was my wife and she have come to me and the kids and that is why i am happy to make every one of you in similar to met with this man and have your lover back to your self His Email: Winnersspellcast@gmail.com or contact him on his website: https://winnersspellcast.blogspot.com or you can also contact him or WhatsApp him on this +2348138289852 thank you so much

    ReplyDelete
  32. This is a testimony that i will tell to every one to hear. i have been married four 5years and on the fifth year of my marriage, another man had a spell to take my lover away from me and my wife left me and the kids and we have suffered for 3years until i meant a post where this man Dr,winner have helped someone and i decided to give him a try to help me bring my love wife home and believe me i just send my picture to him and that of my wife and after 45hours as he have told me, i saw a car drove into the house and behold it was my wife and she have come to me and the kids and that is why i am happy to make every one of you in similar to met with this man and have your lover back to your self His Email: Winnersspellcast@gmail.com or contact him on his website: https://winnersspellcast.blogspot.com or you can also contact him or WhatsApp him on this +2348138289852 thank you so much

    ReplyDelete
  33. Hello friends, I was suffering from ( HEPATITIS B ) for over 4 years,i was hopeless until one of my friend directed me to a man called DR CARE, she said he cure Hepatitis b disease and also said he has helped her friend to cure Hepatitis b virus, and cure other people with different diseases, i never believed her but after a lot of talk, i decided to give the Dr a try, just few days later i contacted him and he told me what to do which i did and he prepared a herbal medicine and sent to me with prescriptions on how i will take it for a period of days. After i finished taking the medicine he told me to go for a test which i also did and when the result came out i was surprised to see that i'm Negative. Big thanks to him. You can also contact him via EMAIL at { drcarevoodoospell@gmail.com } if you need his help for HEPATITIS B, HERPES, HIV CURE ....whatsapp him on +393510530641

    ReplyDelete
  34. i am ERIC BRUNT by name. Greetings to every one that is reading this testimony. I have been rejected by my wife after three(3) years of marriage just because another Man had a spell on her and she left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address AKHERETEMPLE@gmail.com have help a woman to get back her husband and i gave him a reply to his address and he told me that a man had a spell on my wife and he told me that he will help me and after 3 days that i will have my wife back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my wife. Thanks for helping me Dr Akhere contact him on email: AKHERETEMPLE@gmail.com
    or
    call/whatsapp:+2349057261346










    i am ERIC BRUNT by name. Greetings to every one that is reading this testimony. I have been rejected by my wife after three(3) years of marriage just because another Man had a spell on her and she left me and the kid to suffer. one day when i was reading through the web, i saw a post on how this spell caster on this address AKHERETEMPLE@gmail.com have help a woman to get back her husband and i gave him a reply to his address and he told me that a man had a spell on my wife and he told me that he will help me and after 3 days that i will have my wife back. i believed him and today i am glad to let you all know that this spell caster have the power to bring lovers back. because i am now happy with my wife. Thanks for helping me Dr Akhere contact him on email: AKHERETEMPLE@gmail.com
    or
    call/whatsapp:+2349057261346

    ReplyDelete
  35. I just loved your article on the beginners guide to starting a blog.If somebody take this blog article seriously in their life, he/she can earn his living by doing blogging.thank you for thizs article. best blockchain online training

    ReplyDelete
  36. My husband left me for another girl. I needed him back desperately because i loved him so much. I became very worried and needed help. as i was browsing through the internet, I came across a particular testimony about this good Dr Akughe help get ex back fast and stop a divorce or breakup and so on , So I felt I should give him a try. I contacted him and he told me what to do and i did it then he did a (return Love spell) for me. 24 hours later, my husband came back to me crying and begging for my forgiveness. Today I’m so happy and i want to recommend this great spell caster to anyone that truly needs an urgent solution to his or her broken relationships and marriage email him at: akughesolutionhome@gmail. com Simply contact the great “Dr Akughe” If you have any problem contact him and i guarantee you that he will help you., do not cry anymore-contact this powerful spell caster now. Thank you Dr Akughe for saving my broken relationships and brought my husband back to me!” email him at: akughesolutionhome@gmail. com,you can also call him or add him on WhatsApp: +2348162219339

    ReplyDelete
  37. HOW DR SUNNY HELP ME TO FIX MY BROKEN RELATIONSHIP.
    Contact His Email:solutioncentre911@gmail.com
    via what-app;+2349056393169

    Hello my Kathy George, Am here to testify of a great and powerful spell caster named Dr Sunny, I was so confused and devastated when my Husband left me for another girl. I needed him back desperately because i loved him so much. So i contacted this great spell caster for help. He helped me cast a return love spell on my husband and just within 40hours my husband came back to me crying and begging for my forgiveness. Dr Sunny released him to know how much i loved and wanted him back. And He also opened his eyes to picture how much love we have share together. As I am writing this testimony right now i am the most happiest woman on earth. I want to recommend this great spell caster to anyone that truly needs an urgent solution to a love break up Email him at:solutioncentre911@gmail.com or What-App his phone number on +2349056393169 Also specialize on
    1) love Spell
    2) Spells divorce
    3) Spells of marriage
    4) pregnancy problems
    5) Healing spell
    contact this great man if you have a problem for a lasting solution Through Email: solutioncentre911@gmail.com

    ReplyDelete
  38. HOW DR. UNEME brought back my ex lover unemespellben@gmail.com
    Am DONNA, am from UK. After been in a relationship with my Boyfriend for 1 year now and we were planning to get married soon and all of a sudden he left me for another girl. of a truth, I really love this guy and never can I imagine life without him. I further tried all my best to get him back but all my effort to get him back in my life did not work out. It was on this faithful day, I came across some Testimonies on a website about this great spell caster called (Dr. UNEME) any persons claimed that he help them to renew their relationship and bring their ex lover back, I had to contact him because he was my last hope. I contacted him through his email and he assured me that in three days time my boyfriend is going to leave the other girl and come back to me and it was a very great surprise to see my boyfriend coming back to me after three days the spell was done. I am so very happy today that he came back to me and i achieved this with the help of Dr UNEME I equally want to use this opportunity to Tell/Advice to as many who need their ex back, if you need his help you can Contact him through
    EMAIL: unemespellben@gmail.com WHATSAPP HIM @ +2348143813120


    Thank You Once Again Dr.UNEME

    ReplyDelete
  39. I am very happy to inform the general public that I am finally cured from Herpes simplex virus recently with the use of herbal medicine, the powerful herbal medicine cured me completely and i was tested negative after usage, I am using this means to inform other's who have the virus that there is a cure for Herpes simplex 1&2 . It is absolutely true. I was cured by Dr Alli, only him I can recognize who cure Herpes perfectly well. I will advice you to contact this great doctor who God has send to put an end to the sorrowful and deadly disease. Contact him via Email  Allispellhelp1@gmail.com or add him on WhatsApp +2348100772528

    ReplyDelete
  40. I just loved your article on the beginners guide to starting a blog.If somebody take this blog article seriously in their life, he/she can earn his living by doing blogging.thank you for thizs article. best sap hana online training

    ReplyDelete

  41. My name is Sara Smith i am from London, I was in a relationship with Ben and we loved and cherished ourselves for 3 good years and every thing was going on smoothly but JULY 14,2018 a day i can call a lovers day we both had misunderstanding because i answered a call from a guy that is asking me out for a date but i refused,and he told me that the relationship is over and that he is fed up with me and i begged him because i love him so much but he refused me i was so down cast and i felt the world has come to an end for me but my friend told me about a spell caster that helped her sister out in getting her relationship back,a good job and favor in any of her endeavor but at first i was scared but i have to give this man a trial because i love Ben very much and i am not willing to loose him to any woman,so i ordered returning my love spell from this great spell caster that made me a happy woman again to say it all my ex came back to me with much love and a caring heart...i am testifying to this great spell caster Kemi of Goddess. if you need his help you can contact him on: kemilovespelltemple@gmail.com.. THIS MAN IS A GREAT SPELL CASTER HIS EMAIL ADDRESS IS kemilovespelltemple@gmail.com, your life will charged for better.or call him +2349036055364 whatsapp

    ReplyDelete
  42. What a beautiful and wonderful testimony, sometimes things you don't believe can just happen. My name is Adams Vera, from U.S.A am 28 years old i got married at the age of 24 i have only one child and i was living happily. After three years of my marriage my husband behavior became so strange and i don't really understand what was going on, he packed out of the house to another woman i love him so much that i never dreamed of losing him, i try my possible best to make sure that my husband get back to me but all to no avail i cry and i cry seeking for help because i was heart broken until i coincidentally came across an online spell caster called Dr. Osasu , i contacted him and explained to him what i have been going through in my marriage and he gave me the full assurance that my husband will come back to me and my marriage will be restored, He told me what to do to get my husband back and i did, he said after 3days my husband will come back to me and start begging, it really happen it was so surprising and everything was just like a miracle, ever since my family have been living with so much happiness and our relationship was now very tight because of this great and powerful spell caster.he is a very great and powerful spell caster that can be trusted and there is nothing concerning life issues he cannot solve because i am a living testimony. i know there are so many people out there who are going through similar problems in one way or the other, believe me this is the right spell caster to contact and all your problems will be forgotten. contact Dr. Osasu viaWhatsapp: +2347064365391 Email:Account drosasu25@gmail.com

    ReplyDelete
  43. Hello I'm From Memphis Tennessee, USA I feel so joyful today because of the help Dr  Sunny has rendered to me for  getting my Husband back with his spell. I have been married for 4 years and it has been so terrible because my husband was cheating on me and was seeking for a divorce. But when i came across Dr Sunny Email, on the internet posted by a lady, i decided to get in touch with him and i explained my situation to him and then seek his help but to my greatest surprise he told me that he will help me with my case for there is no problem without a solution. Here i am celebrating because my Husband is back home and am really enjoying my marriage, what a great celebration. i will keep on testifying on the internet because Dr Sunny is truly a real spell caster. Why not contact Dr Sunny now if you are facing any challenges in your relationship life. Email solutioncentre911@gmail.com Also specialize i1) love Spell
    2) Spells divorce
    3) Spells of marriage4) Penis enlargement 5) Pregnancy problems6) Healing spell
    contact this great man if you have a problem for a lasting solution Through Email: solutioncentre911@gmail.com

    ReplyDelete

  44. HOW I GET MY EX BACK WITHIN 3 DAYS

    i sincerely want to thank a great spell caster called Dr Ilekhojie for helping me to bring back my husband to me and my kids. after many years of marriage, my husband left me and my kid, and ran away with his new girlfriend to san francisco to start up their life without thinking about me and my son. I felt like my life was about to end, and was falling apart. After years of our separation i could not take it anymore so i decided to visit a friend who also encounter similar issue but she is living happily with her man now , to seek advice from her on how she get her ex husband back again.when i get there i explain everything to her and she told me not to worry that she will link me up with the spell caster who cast a spell on her husband that make him to come back to her. i pick her advice and i strongly hold onto it.then I contacted Dr Ilekhojie (gethelp05@gmail.com) and after I explained my problem,he told me not to worry that i have no problem in getting my husband back again he gave me 4 days assurance that my husband will come looking for me that when he come i should accept him back i told him that i will whole heartedly welcome him back. In just 3 days my husband came back to us and apologize for all the pain he have bring to the family. We solved our issues, and we are even happy more than ever before. Dr Ilekhojie is the best spell caster to solve any kind of problem and sickness you have.. I really appreciate the love spell you cast for me to get the man back to my life i will keep sharing more testimonies to people about your good work. if you want your ex back and you don,t know what to do kindly email gethelp05@gmail.com or contact him via whatsapp +2348147400259

    ReplyDelete
  45. What a beautiful and wonderful testimony, sometimes things you don't believe can just happen. My name is Adams Vera, from U.S.A am 28 years old i got married at the age of 24 i have only one child and i was living happily. After three years of my marriage my husband behavior became so strange and i don't really understand what was going on, he packed out of the house to another woman i love him so much that i never dreamed of losing him, i try my possible best to make sure that my husband get back to me but all to no avail i cry and i cry seeking for help because i was heart broken until i coincidentally came across an online spell caster called Dr. Osasu , i contacted him and explained to him what i have been going through in my marriage and he gave me the full assurance that my husband will come back to me and my marriage will be restored, He told me what to do to get my husband back and i did, he said after 3days my husband will come back to me and start begging, it really happen it was so surprising and everything was just like a miracle, ever since my family have been living with so much happiness and our relationship was now very tight because of this great and powerful spell caster.he is a very great and powerful spell caster that can be trusted and there is nothing concerning life issues he cannot solve because i am a living testimony. i know there are so many people out there who are going through similar problems in one way or the other, believe me this is the right spell caster to contact and all your problems will be forgotten. contact Dr. Osasu viaWhatsapp: +2347064365391 Email:Account drosasu25@gmail.com

    ReplyDelete
  46. This is my testimony that i will tell everyone to hear i have been married for 3 years and on the 4 years of my marriage another woman had a spell to take my husband away from me and my husband left me and the kids and we have suffered for 1 year and 6 months until i meant a post where this man Dr OSAYI have helped someone and i decided to give him a try to help me bring my love husband home and believe me i just send my picture to him and that of my husband and after 3 days as he have told me i saw a car drove into the house and behold it was my husband and he have come to me and the kids and that is why i am happy to make every one of you in similar to met with this man and have your lover back to your self His email (osayisolutionspellhome@gmail.com ) or call or WhatsApp him ( +2348051843752 ) he can also help on and cures:-
    (1) PREGNANCY SPELL
    (2) Spell Magic
    (3) Spells for healing
    (4) Spells of invisibility
    (5) Spells for wealth and fame
    (6) Spell to get a good job
    (7) Spells for a strong love and relationship
    (8) Spell to bring your ex back
    (9) Spell for protection from the danger
    (10) HIV / AIDS
    (11) HERPES
    (12) Hepatitis B.
    This man has great power and is incredibly generous.No problem is too big for him to solve..Contact him now,THANKS Dr OSAYI (His WhatsApp Number; +2348051843752 ).

    ReplyDelete
  47. Strong And Powerful Love Spell To Win Your Ex Back.. I have decided that i am going to spend the whole day on the internet just to make sure that a lot of people are able to read this my testimony about Dr.happy who is a powerful spell caster from Africa, After been abandon by my lover i was so lonely that very day that i decided to go through the net for some relationships tips, I never knew that this was the road map that will secure the return of my lover. After reading a lot of tips on how to restore my relationship in a more better way i discovered that Dr.happy has a lot of recommendation than other spell casters, So with this i had my mind made up that Dr.happy was the right person for the job, And i contacted Dr.happy through his details which i saw on the internet and i was so happy that i chose to work with Dr.happy because his work was 100% perfect and the spell brought my lover back to me with fast relief you can also contact him for help now email.. happylovespell2@gmail.com
    Website...happylovespell2.webnode.com/
    Whatsapp/cal +2348133873774

    ReplyDelete
  48. Dr.Mamudu the best spell caster online restore my broken relationship and i highly recommends Dr.Mamudu to anyone in need of help!
    My husband left me for another woman 3 months ago and ever since then my life have been filled with pains sorrow and heart break because he was my first love whom i have spent my entire life with. A friend of mine told me he saw some testimonies of a spell caster called Dr Mamudu that he can bring back lover within some few days, i laugh it out and said i am not interested but because of the love my friend had for me, she consulted the great priest on my behalf and to my greatest surprise after 2 days my husband called me for the very first time after three months that he is missing me and that he is so sorry for every thing he made me went through.He came back to me and now we are happy together. I still can’t believe it, because it highly unbelievable. Thank you Dr.Mamudu for bringing back my lover and also to my lovely friend who interceded on my behalf, for any one who might need the help of this great priest here is the email address: drmamudu47@gmail. com , you can also call him or add him on Whats-app: +2348143284524…

    ReplyDelete
  49. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    blockchain online training
    best blockchain online training
    top blockchain online training

    ReplyDelete
  50. My wife left me and went on vacation with her ex-lover and for the past four months I have not heard or seen her. I never knew I would experience such a heartbeat from my wife after 12 years of marriage with 3 children. My manager at work noticed that I could no longer concentrate on my workstation as I used to. He offered me a chat to discuss with him and I told him what I was going through. After I explained to my boss, he replied to Lord Osasu , who is a stake collection. I joined Lord Osasu on his WhatsApp line on +2347064365391 after talking to my boss and he told me that my situation will be resolved within 24 hours with his powerful spell form. I followed all his instructions and I believed and had faith in him. He prepared a love spell for me that got my wife back within 24 hours and now we both have lived well more than we used to. I don't know if anyone out here needs help but here is Lord Osasu WhatsApp line +2347064365391 email is: drosasu25@gmail.com if you need help in your love life.

    ReplyDelete
  51. Greetings to every one that is reading this testimony. I had been rejected by my husband after five(5) years of marriage just because another woman had cast a spell on him and he left me with 2 kids to suffer. One day when i was reading through the web, i saw a post on how he help a woman to get back her husband and i gave him a chance he told me that my husband is under spell, he said that he will help me and after 7 days that i will have my husband back. i believed he and today i am glad to let you all know that this spell caster has the power to bring lovers back now my husband is back with after 7 days . he also gave me a financial magic ring to boost my business and removed bad luck. i am now happy with my husband. Thanks you Dr. love please contact him at (lovespelldoctor0@gmail. com)

    ReplyDelete
  52. Hello Viewers. Life has been so miserable after my Husband broke up with me 2 year ago. I never thought he could hurt me just like that then i realized how much i loved him. When he ended our relationship and i had to look for options to make sure i get him back to myself because i wasn't living fine anymore. I was directed to a Babalawo known as Dr Ogbeifun by a family friend who claimed he helped her with Court case, and protection in her work to go higher than others. Then I contact with the Babalawo and i was surprised and amazed when my Husband came back to me with he knees on the floor pleading to me for forgiveness to take he back as my lover. I thought i was dreaming because all this happened just within 24 hours and it happened as the spell Doctor as said. For that wonderful encounter with this man, i took a decision on my path that i will let the world know about DR OGBEIFUN for he's able and capable to solve any problems. Get in touch with him email : ifababalawospelltemple@gmail.com
    Add him on WhatsApp: +2348050680253

    ReplyDelete
  53. Am here to say a big thank you to Dr Sam for his great powerful love spell and his great spirits for saving my relationship. No one would have believe that I and my ex will ever come back together again lovers. But this great spell caster united us in just 48 hours. Dr Sam is truly a real and honest online spell caster. Contact him now on:okokakspellhome@gmail.com or whatsApp him +2349060421250 and he will help you solve all your problem

    ReplyDelete
  54. My name is Valary West.I'm from Canada, My husband and I have been married for about 7 yrs now. We were happily married with two kids, a boy and a girl. 3 months ago, I started to notice some strange behaviour from him and a few weeks later I found out that my husband is seeing someone else. He started coming home late from work, he hardly care about me or the kids anymore, Sometimes he goes out and doesn't even come back home for about 2-3 days. I did all I could to rectify this problem but all to no avail. I became very worried and needed help. As I was browsing through the internet one day, I came across a website that suggested that Psychic odumeje  can help solve marital problems, restore broken relationships and so on. So, I felt I should give him a try. I contacted him and told him my problems and he told me what to do and i did it and he did a spell for me. 28 hours later, my husband came to me and apologised for the wrongs he did and promise never to do it again. Ever since then, everything has returned back to normal. I and my family are living together happily again.. highly recommend Psychic odumeje, he is Powerful and really love spell caster. If you have any problem contact him and i guarantee you that he will help you. he will not disappoint you.Email:  odumejetemple@gmail.com or call / whataspp +2349012479806

    ReplyDelete
  55. Thank you sir for your genuine spells. This is really incredible, and I have never experienced anything like this in my life. Before i met you Sir, i have tried every possible means that i could to get my wife back, but i actually came to realize that nothing was working out for me, and that my wife had developed lot of hatred for me.. I thought there was no hope to reunite with my ex wife and kids. But when i read good reviews about your work sir, i decided to give it a try and i did everything that you instructed me and i Trusted in you and followed your instructions just as you have guaranteed me in 48 hours, and that was exactly when my wife called me.. We are more contented now than ever. Everything looks perfect and so natural! Thank you so much for your authentic and indisputable spells. Thanks Sir for your help. So I promise to tell the world about you great If you need help in your marriage of broken relationship,please contact Dr Osasu right now for urgent help WhatsApp +2347064365391 or Email drosasu25@gmail.com I want every one who is facing any problem should also give a testimony soon. Just like me today

    ReplyDelete
  56. My name is Valary West.I'm from Canada, My husband and I have been married for about 7 yrs now. We were happily married with two kids, a boy and a girl. 3 months ago, I started to notice some strange behaviour from him and a few weeks later I found out that my husband is seeing someone else. He started coming home late from work, he hardly care about me or the kids anymore, Sometimes he goes out and doesn't even come back home for about 2-3 days. I did all I could to rectify this problem but all to no avail. I became very worried and needed help.

    As I was browsing through I am very happy today with my family. My name is West Valary  living in Canada, My husband left me for good 3 months now, and i love him so much, i have been looking for a way to get him back since then. i have tried many options but he did not come back, until i met a friend that darted me to Dr. Odumeje a spell caster, who helped me to bring back my husband after 48 hours. Me and my husband are living happily together today, That man is great, you can contact him via email odumejetemple@gmail.com .

    Now i will advice any serious persons that found themselves in this kind of problem to contact him now a fast solution without stress.. He always hello, now i call him my father. contact him now he is always online email odumejetemple@gmail.com or contact him on his whatsapp mobile line +2349012479806

    you can also contact me for more info about the DR here is my email. westvalary@gmail.com   

    ReplyDelete


  57. Am jeremiah, I am testifying about a great hebal man that cured my wife of hepatitis B and liver cirhosis. his name is Dr oniha. My wife was diagnose of hepatities two years ago, i almost spent all i had then, until i saw dr oniha recommendation online, and i call him, then he told me how to get the herb. You can call him on +2347089275769 or email him at dronihaspell@yahoo.com

    ReplyDelete
  58. Hi everyone I'm Mrs Katrina Bennett, My husband divorced me 2 years ago to live with another woman and i have tried have him back but i could not, so i try to do many things to get him back and he refuse to come back. One faithful Friday morning, I visit a forum for tips on how to get your Ex back and there i saw a lady testifying on how Dr.alusi helped her to get her husband back after he was tie down with a spell by another woman. Although I never believed in spiritual work I reluctantly tried him because I was desperate and i contact him and explain my problems to him, to my greatest surprise Dr.alusi helped me to bring back my husband after 5days and now my relationship is more perfect just as he promised. Getting your ex back permanently does not only bring back someone you love but it will also reunite your lovers feelings. My husband now treats me like a Queen and always says he loves me all the time. If you are passing through difficulties in your relationship, Doctor alusi can help solve marital problems, restore broken relationships and some other things.I can assure he's highly potent and reliable. Email him for urgent help [dr.alusistanley@gmail.com] or +2348146050373.

    ReplyDelete
  59. I need my ex lover back Contact: Drsikama@gmail.com and his result is 100% sure and guaranteed!.
    I got a divorce from my husband when I was six months pregnant with my second child. We had been arguing and quarreling nonstop since the day our first child was conceived, no love nor trust from him anymore so he divorced me. And all these whiles, I have been trying all different means to get him back, I also tried some different spell casters here in the United States, but none of them could bring Richard back to me. It was only Dr. sikama who guaranteed me an urgent 28 hours spell casting, and he assure me that my husband will be with me again. I am writing to offer my thanks and deep gratitude to you for keeping your promises, and for using your gifted and great powers to bring him back home. I was thrilled to know that you are specialized in reuniting Lovers. Thank you Sir, for helping me through the worst times of my life, for being such a great spell caster, and for giving me a love spell that has brought me so much joy in my marriage. My husband is back and promise never to leave me again. If you doubt his ability, trust me. You should take a chance. It pays off in ways you could never even imagine. If you are their right now and you need a powerful and urgent love spell to bring back your ex kindly contact Dr. sikama right now he is the only answer to restore your broken relationship or marriage. Here’s his contact: Email him at:drsikama@gmail.com ,Call/WhatsApp:+2348130725051

    ReplyDelete
  60. Hi!!
    I want to specially thank Dr. Godsent Yare for helping me get cured from Genital Herpes Virus. I was diagnosed last 2 summer, and my doctor said no cure for the virus. I was in big trouble until I saw this YouTube post https://youtu.be/Uw-l6rfcOl4 online testifying about Dr. Godsent Yare, How he cured A lady with ALS/MND disease using his herbal healing cure. I contacted him base on the good testimonies I was seeing about him on the internet, how he cured so many people from different diseases and Virus with his roots, herbs and healing oil. I placed an order and received medicines after 4 working days and commerce treatment as instructed,  now I'm happily sharing my own testimony to the world that I'm cured. If you need help to cure HSV1-2 or any other disease or virus, contact him today on his email; dryareherbalcurehome@gmail.com Or Call/Whatsapp his number on +2348164653711, +2348148010628. I hope that everyone reading this post should refer others who need help to cures to Dr. Yare's website; http://bit.ly/2dBFYeW for additional information. When people know better, they do better ! You will be glad you did.

    Covid-19 Pandemic is real, stay home stay safe.

    ReplyDelete
  61. Kidney donor needed urgently at Apollo Hospital, we offer huge amount for one kidney only contact me via WhatsApp number: +918122208392 Email: apollohospitalkidneydep@gmail.com

    ReplyDelete
  62. I want to thank Dr Emu a very powerful spell caster who help me to bring my husband back to me, few month ago i have a serious problem with my husband, to the extend that he left the house, and he started dating another woman and he stayed with the woman, i tried all i can to bring him back, but all my effort was useless until the day my friend came to my house and i told her every thing that had happened between me and my husband, then she told me of a powerful spell caster who help her when she was in the same problem I then contact Dr Emu and told him every thing and he told me not to worry my self again that my husband will come back to me after he has cast a spell on him, i thought it was a joke, after he had finish casting the spell, he told me that he had just finish casting the spell, to my greatest surprise within 48 hours, my husband really came back begging me to forgive him, if you need his help you can contact him with via email: Emutemple@gmail.com or add him up on his whatsapp +2347012841542 is willing to help any body that need his help.
    For more details about Dr Emu visit his Website: http://emutemple.website2.me/

    ReplyDelete
  63. Divorce and marital breakthrough save your marriage / relationship from breakup and Divorce? you can contact Dr. Raypower through email Urgentspellcast@gmail.com or call him directly or WhatsApp on +1 (424) 330-8109

    Good day everybody, My names are Alicia Leonard i am out here to spread this good news to the entire world on how I got my ex husband back. It all started when my husband cheated on me with another woman unknowing to him that the woman is a wizard, the woman castes a spell on my husband which made my husband change his feelings towards me and the kids and broke our 6 years marriage. I was confused and stressed because of the pains of being a single mother, so i called a friend and explained my marital challenges to her, she instructed and directed me to contact this great powerful spell caster called Dr. Raypower, The main reason why she instructed me to contact Dr Raypower was because in recent times she have read some testimonies on the internet which some people has written about the powerful spell caster Dr Raypower and i was so pleased and i decided to seek for assistance from him which he did a perfect job by casting a spell on my husband and utilize the powers of the other woman which made him to come back to me and beg for forgiveness. I will not stop publishing his name on the net because of the good work he is doing. To everyone with marital problem, divorce issues, lost lover or any relationship related issues, you can contact Dr. Raypower the powerful urgent spell caster via details below 
    Email: Urgentspellcast@yahoo.com or Urgentspellcast@gmail.com  
    Website: https://urgentspellcast.wordpress.com/  and   http://urgentspellcast.website2.me/
    Blog: https://drraypower.blogspot.com/  
    Call/WhatsApp: +1 (424) 330-8109

    ReplyDelete
  64. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    blockchain online training
    best blockchain online training
    top blockchain online training

    ReplyDelete
  65. I want to quickly crave your indulgence and bring to your notice a powerful spell caster called Dr LOVE0 who in just 3 days of contact was able to bring back my lost love am short of words to thank him and i have resort to this medium of telling the world at large about him. His truly amazing and kind contact him today via Email: doctor0lovespell@gmail.com or check his blogs: https://doctorlovespell0.blogspot.com/ or visit his FB page: https://www.facebook.com/Lovespellthatworkfastusa  .He is also able to cast spells like
    1:Pregnancy Spell
    2:Jail Release
    3:Prosperity Spell
    4:Lottery Spell
    5:Cancer cure ETC......












    I want to quickly crave your indulgence and bring to your notice a powerful spell caster called Dr LOVE0 who in just 3 days of contact was able to bring back my lost love am short of words to thank him and i have resort to this medium of telling the world at large about him. His truly amazing and kind contact him today via Email: doctor0lovespell@gmail.com or check his blogs: https://doctorlovespell0.blogspot.com/ or visit his FB page: https://www.facebook.com/Lovespellthatworkfastusa  .He is also able to cast spells like
    1:Pregnancy Spell
    2:Jail Release
    3:Prosperity Spell
    4:Lottery Spell
    5:Cancer cure ETC......




    ReplyDelete
  66. When I found Dr. Paul I was in desperate need of bringing my ex lover back. He left me for another woman. It happened so fast and I had no say in the situation at all. He just dumped me after 3 years with no explanation. I contact Dr.Paul through his website and He told me me what i need to do before he can help me and i did what he told me to, after i provided what he wanted, he cast a love spell to help us get back together. Shortly after he did his spell, my boyfriend started texting me again and felt horrible for what he just put me through. He said that I was the most important person in his life and he knows that now. We moved in together and he was more open to me than before and then he started spending more time with me than before. Ever since Dr. Paul helped me, my partner is very stable, faithful and closer to me than before. I highly recommends Dr. Paul to anyone in need of help. Email: astoriashrine@ gmail com, Call him or add him on whatsapp via: +2349051441669

    ReplyDelete
  67. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    blockchain online training
    best blockchain online training
    top blockchain online training

    ReplyDelete
  68. It’s obvious some patients with herpes are being enslaved to the antiviral and other supplementary Orthodox medicine just to help suppress the virus and not a cure. I have been with the virus since 2015 until I was introduced by a blogger who also narrated her story online on how she was cured of Genital Herpes after using Dr Sikies Herbal Medicine. This is a year and 2 weeks since I was delivered from genital Herpes. All thanks to God for using this Great herbalist to heal me. I have promised to keep telling good things about Dr Sikies. Please feel free to share Your problems with him and don’t forget to tell him I did refer you to Him. Thanks. Write him on mail Drsikies@gmail.com He deals with Alzheimer virus, Cancer, HIV, Herpes, Genital, warts, ALS, BV, UTI, Virginal infection, Genital, Wart, HPV, Hepatitis A/B, Good luck, HSV, Pregnancy, Ex back.  

    here is his website: https://drsikiesherbalcure.weebly.com 

    you can reach me via mail: anitalawson515@gmail.com

    ReplyDelete