Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Using a formula to find strings in two fields

SandSlinky
7 - Meteor

Hello!

 

I'm trying to search for a list of words and phrases in two separate fields ("Story" and "Blurb). I want to treat them a little differently depending on which field they appear in. I have assigned certain importance weights (a score of 1-3) to each word / phrase, which will be taken as the result if they appear in the field "Story". If they appear in the field "Blurb", however, I want to add 3 points to this output. Using the "Summarize" function, the sum of this output is taken to result in a total score.

I have tried doing this in various ways, including the method in the screenshot below, using two separate formulas within a single "Formula" function to result in the same output column, "Found". However, this does not seem to be working, as I am getting the same results as before I entered the formula for the "Blurb" field, even in cases where words from my search list do appear in that field. Does anyone know why this is and how to fix it?

 

SandSlinky_0-1590354389795.png

 

21 REPLIES 21
SandSlinky
7 - Meteor

I have a low of columns, some very big, so this will probably get really messy, but let's see:

 

backers_countblurbcategoryconverted_pledged_amountcountrycountry_displayable_namecreated_atcreatorcurrencycurrency_symbolcurrency_trailing_codecurrent_currencydeadlinedisable_communicationfriendsfx_rategoalidis_backingis_starrableis_starredlaunched_atlocationnamepermissionsphotopledgedprofileslugsource_urlspotlightstaff_pickstatestate_changed_atstatic_usd_rateurlsusd_pledgedusd_typeurls2Story
59While being in sauna in Finland, Jussi remembers a dream where he was far away. In Mexico.{"id":296,"name":"Fantasy","slug":"film & video/fantasy","position":8,"parent_id":11,"parent_name":"Film & Video","color":16734574,"urls":{"web":{"discover":"http://www.kickstarter.com/discover/categories/film%20&%20video/fantasy"}}}3774MXMexico1498253583{"id":1834273929,"name":"Aleksi Herrera Kivinen","is_registered":null,"chosen_currency":null,"is_superbacker":null,"avatar":{"thumb":"https://ksr-ugc.imgix.net/assets/017/818/362/c256043730e1270c226b2fce513341f4_original.jpg?ixlib=rb-..."}}}MXN$TRUEUSD1504891190FALSE 0.05360908650001954687230 FALSE 1502903990{"id":116545,"name":"Mexico City","slug":"mexico-city-mx","short_name":"Mexico City, Mexico","displayable_name":"Mexico City, Mexico","localized_name":"Mexico City","country":"MX","state":"Distrito Federal","type":"Town","is_root":false,"expanded_country":"Mexico","urls":{"web":{"discover":"https://www.kickstarter.com/discover/places/mexico-city-mx","location":"https://www.kickstarter.com/..."}}}SAUNA {"key":"assets/017/233/410/3e8f35b5266d224b4d9bcde536efb3f3_original.jpg","full":"https://ksr-ugc.imgix.net/assets/017/233/410/3e8f35b5266d224b4d9bcde536efb3f3_original.jpg?ixlib=rb-..."}66500{"id":3050053,"project_id":3050053,"state":"inactive","state_changed_at":1498253583,"name":null,"blurb":null,"background_color":null,"text_color":null,"link_background_color":null,"link_text_color":null,"link_text":null,"link_url":null,"show_feature_image":false,"background_image_opacity":0.8,"should_show_feature_image_section":true,"feature_image_attributes":{"image_urls":{"default":"https://ksr-ugc.imgix.net/assets/017/233/410/3e8f35b5266d224b4d9bcde536efb3f3_original.jpg?ixlib=rb-..."}}}saunahttps://www.kickstarter.com/discover/categories/film%20&%20video/fantasyTRUEFALSEsuccessful15048911910.05629315{"web":{"project":"https://www.kickstarter.com/projects/1834273929/sauna?ref=discovery_category_newest","rewards":"http..."}}3743.494475domestichttps://www.kickstarter.com/projects/1834273929/saunaStoryRisks and challengesStory Español Suomeksi English Tavoite on Meksicon Pesoina  / Goal is in Mexican Pesos $1 US Dollar  = 17.50 Mexican Pesos                 1€  = 21.90 Mexican PesosEl sauna es probablemente una de las manifestaciones más representativas de la cultura finlandesa. Más allá de ser un baño de vapor, es un espacio en el que las personas pueden expresar sus emociones. Ser ellas mismas. Sauna on luultavasti yksi suomalaisen kulttuurin tyypillisimpiä piirteitä. Enemmänkin kuin pelkkä pesupaikka, sauna on tila jossa tunteet pääsevät pinnalle. Saunassa voi olla oma itsensä. Sauna is probably one of the most representative aspects of the Finnish culture. Far beyond a simple steam bath, it's a space where people can show their emotions. Be themselves.¿De qué es la historia?Mistä tarinassa on kysymys?What is the story about?Jussi, un finlandés de unos treinta años que vive en algún pequeño pueblo de Finlandia está en el sauna con un amigo. Estando ahí, recuerda un sueño en el que se encuentra en un lugar lejano (México), donde al inicio se le aparece un hombre-pájaro del tipo Martín Pescador. Sin embargo, el Hombre-Martín Pescador desaparece rápidamente.Jussi, noin 30-vuotias suomalainen mies jostakin pikkukylästä, on saunassa kaverin kanssa. Siellä hän muistaa unen jossa hän seikkailee  kaukana Meksikossa, missä hänen eteensä ilmestyy kuningaskalastajalintu-mies. Ilmestys kuitenkin katoaa pian näkyvistä.Jussi, a Finn who is about 30 years old and lives in a small town somewhere in Finland goes to sauna with a friend. There he remembers a dream in which he is in a place far away (Mexico), where at the beginning of the dream a Kingfisher-man (a birdman) appears in front of him but suddenly vanishes. El Hombre-Martín pescador causa tanto asombro en Jussi que todo el sueño busca volver a verlo con la ayuda de Nube, una mujer mayor que es guía de soñadores y que lo acompañará en esta aventura.Kuningaskalastajamies tekee Jussiin niin suuren vaikutuksen, että koko loppu-unensa ajan hän yrittää nähdä sen uudestaan. Apunaan hänellä on Nube, vanhempi nainen jonka tehtävänä on ohjata unennäkijöitä. Tässä tapauksessa hän tukee Jussia seikkailussaan Meksikossa. The Kingfisher-man causes such an impression in Jussi that he decides to look for him for the rest of his dream with the help of Nube, an old lady who is a dreamer guide and will string along Jussi in this adventure.Jussi es un hombre serio que podría parecer poco expresivo. Sin embargo, gracias a las condiciones que crea el sauna, podemos conocerlo más a fondo hasta el punto de enterarnos de sus sueños. Jussi on vähäpuheinen mies joka saattaa päällisin puolin vaikuttaa hieman ilmeettömältä. Saunan luoman tunnelman ansiosta voimme kuitenkin tutustua häneen paremmin hänen oman unensa kautta. Jussi is a man who may look reserved, nevertheless because of the conditions that sauna creates we can get to know him till a point of getting to know his dreams. ¿De dónde viene Sauna?Mistä Sauna tulee? Where does Sauna come from?Toda mi vida ha sido una fusión entre la cultura finlandesa y la mexicana, ya que mi familia materna es del país nórdico y la paterna de México. Los paisajes y tradiciones de cada país han estado presentes desde que tengo memoria y es con Sauna que quiero hablar sobre estos dos mundos de la manera más bella que conozco, a través del cine. Koko elämäni on ollut vuoropuhelua suomalaisen ja meksikolaisen kulttuurin välillä. Äitini sukujuuret ovat Suomesta, ja isän Meksikosta. Kummankin maan maisemat ja traditiot ovat olleet osa elämääni syntymästäni saakka, ja Saunassa haluan kertoa näistä maailmoista kauneimmalla tuntemallani tavalla, elokuvan kautta. My entire life has been a fusion between the Finnish and the Mexican cultures because my mother if from the Nordic country and my father from Mexico. The landscapes and the traditions of each country have been present in my life since I was born and it´s with Sauna that I want to speak about this in the most beautiful way I know, making a film.Finlandia y México, a pesar de estar a casi diez mil kilómetros de distancia, tienen similitudes interesantes. En Sauna aspectos de ambas culturas se unen y conviven. El idioma no es un obstáculo, pues aunque se hable en español y en finlandés, los personajes se entienden sin problema.Vaikka välimatka Suomen ja Meksikon välillä on melkein kymmenen tuhatta kilometriä, näiden kahden kulttuurin välillä on kiehtovia kohtauspintoja. Saunassa kulttuurit kohtaavat toisensa. Kieliongelmia ei ole, sillä unessa henkilöt ymmärtävät toistensa puhetta - suomea tai espanjaa - kielestä huolimatta. Finland and Mexico, despite being almost ten thousand kilometers away from each other, have interesting similarities. In Sauna aspects of both cultures unite and coexist. Language is not an obstacle, because even though the characters speak in Spanish and Finnish, they understand each other without any problem. Ilustraciones por Alejandro Cabrera Los rodajes: Finlandia y MéxicoKuvaukset: Suomi ja MeksikoThe filming: Finland and MexicoSauna es un cortometraje en el que se pretende hablar de ambos países, así que decidimos grabar las tomas de la locación del sauna en Finlandia, y las del resto del sueño en México, para así captar de una forma más auténtica ambas realidades. El primer rodaje se realizó a mediados de julio en el pueblo de mis abuelos, Kuhmo, al noreste del país.Lyhytfilmissämme kerromme näistä kahdesta maasta, ja päätimme filmata sauna-kohtaukset Suomessa, ja lopun Meksikossa, jotta voisimme kuvata molempia maailmoja mahdollisimman autenttisesti. Suomen osuus kuvauksista tehtiin heinäkuun alussa isovanhempieni luona Kuhmossa Itä-Suomessa.As this is a film that aims to talk about both countries, we decided that we should do the sauna part in Finland, and the rest of the film in Mexico, in order to catch the nature of both of these realities as authentically as possible. The filming took place in my grandparents' town, Kuhmo, in the Northeast part of Finland in mid-July. A finales del mes de agosto será el rodaje del sueño de Jussi en México. Se grabará en locaciones que por sí mismas brindarán la magia única que tiene este país, donde el color y los elementos en cuadro nos envolverán en un ambiente surreal digno de un sueño. Un globo aerostático, un río tropical, una cantina, caminos rurales y un aviario serán las locaciones del sueño.Elokuun lopussa kuvaamme Jussin unen Meksikossa. Kuvauspaikat jo itsessään tulvivat sitä taianomaisuutta jota Meksiko on täynnä, ja värit ja kuvien elementit kietovat meidät surrealistiseen ilmapiiriin, joka hyvinkin voisi kuulua uneen. Kuumailmapallo, trooppinen joki, cantina-baari, pölyiset maanseututiet ja suuri lintutarha kuuluvat tähän unimaailmaan. In the last days of this month we will shoot Jussi´s dream in Mexico. The locations will create for themselves a unique magical atmosphere that this country has, where the color and elements in the frame will wrap us in a surreal atmosphere worthy of a dream. A hot air balloon, a tropical river, a cantina, dusty roads in the countryside and a big aviary belong to this dream world. ¿Para qué se usará el dinero?Mihin rahat käytetään?How will the money be used?Al ser una producción internacional, los costos de este cortometraje han sido muy altos; vuelos, equipaje extra para el equipo de grabación y transporte hasta Kuhmo (muuuuy lejos). El dinero se utilizará para pagar una parte de estos gastos así como para pagar el diseño de producción: arte, vestuario y maquillaje.Lyhytfilmimme tuotetaan kahdessa maassa, jonka vuoksi kustannukset nousevat korkeiksi. Maksamme lennoista, ylimääräisistä matkatavaroista kameroitten ja mikrofonien takia, ja pitkistä maakuljetuksista Kuhmoon (eli hyvin kauas) saakka. Rahat käytetään näihin menoihin, samoin kuin kattamaan osa kulissien, pukujen ja maskeerausten suunnittelusta ja toteuttamisesta. As this is an international production, the short film's costs have been relatively high: flights, extra luggage for the equipment and transport to Kuhmo (very far away). The money will be used to pay a part of these expenses as well as to pay a part of the production design: art, costume design and makeup.****Llegando a la meta conseguiremos fondear el mínimo, sin embargo si conseguimos fondear más vamos a poder cubrir cosas como el pago a actores y las comidas.********Päästyämme minimitavoitteeseen peruskustannukset on katettu, mutta jos ylitämme tavoitteemme,  voisimme kattaa myös näyttelijöiden palkkoja ja ruokatarjoiluja. ********By achieving the goal we will have covered the minimum. Nevertheless, if we exceed the objective, we will also be able to cover payments of actors as well as catering expenses.***** Pahoittelemme sitä, että korkeitten lähetyskustannusten vuoksi palkinnot pätevät vain Meksikossa. Liitämme kuitenkin kiitokset lopputeksteihin, ja lähetämme salasanan lyhytfilmin katselua varten. Mutta jos sattuisit käymään Meksikossa, voisimme antaa sinulle muutkin palkinnot!*Unfortunately, because of the high shipping fees, the rewards only apply within Mexico. Nevertheless, we will give the acknowledgements on screen and send the password to watch the short film. However, if you happen to come to Mexico, we would be happy to give you all the rewards.¿Quiénes somos? Ketä olemme? Who are we?Todos los miembros del crew somos estudiantes de octavo semestre de la carrera de cine en la universidad CENTRO y estamos por graduarnos. Nuestra trabajo final para obtener el grado de Licenciatura consiste en hacer un cortometraje.Kaikki tiimin jäsenet olemme viimeisen lukukauden elokuva-alan opiskelijoita CENTRO-nimisestä yliopistosta Mexico Citystä. Valmistuminen on jo lähellä ja lopputyöksi teemme lyhytfilmin.  All of us are 8th semester film students at CENTRO university (Mexico City) and we are about to graduate. To obtain the degree we will prepare a short film as our final work.  ¡Bienvenidos al sueño de Jussi!Tervetuloa Jussin uneen!¡Welcome to Jussi's dream!                                                                                              Aleksi Herrera Kivinen Ilustración por Alejandro Cabrera  Risks and challengesSi no logramos llegar a la meta no podremos invertir en el diseño de arte, que es de lo más importante para sentirnos dentro de un sueño. Necesitamos de tu ayuda para ayudarle a Jussi a vivir su sueño :)Learn about accountability on KickstarterQuestions about this project? Check out the FAQReport this project to Kickstarter
36Born out of a mother's desire to provide a safe, nontoxic and natural way for her child to explore and experience art.{"id":54,"name":"Mixed Media","slug":"art/mixed media","position":6,"parent_id":1,"parent_name":"Art","color":16760235,"urls":{"web":{"discover":"http://www.kickstarter.com/discover/categories/art/mixed%20media"}}}1553USthe United States1412750625{"id":795426180,"name":"Eza Borchardt","slug":"lepetitmatisse","is_registered":null,"chosen_currency":null,"is_superbacker":null,"avatar":{"thumb":"https://ksr-ugc.imgix.net/assets/009/303/434/2af51cf9556fab80814386d4791d301d_original.jpg?ixlib=rb-..."}}}USD$TRUEUSD1415946877FALSE 1150001464551434 FALSE 1413956077{"id":2352559,"name":"Alameda","slug":"alameda-alameda-ca","short_name":"Alameda, CA","displayable_name":"Alameda, CA","localized_name":"Alameda","country":"US","state":"CA","type":"Town","is_root":false,"expanded_country":"United States","urls":{"web":{"discover":"https://www.kickstarter.com/discover/places/alameda-alameda-ca","location":"https://www.kickstarter...."}}}Le Petit Matisse - Imagine . Create . Share {"key":"assets/011/900/169/0e9ebc83f4de290e25dce2ab91fb7058_original.jpg","full":"https://ksr-ugc.imgix.net/assets/011/900/169/0e9ebc83f4de290e25dce2ab91fb7058_original.jpg?ixlib=rb-..."}1553{"id":1423143,"project_id":1423143,"state":"inactive","state_changed_at":1425915878,"name":null,"blurb":null,"background_color":null,"text_color":null,"link_background_color":null,"link_text_color":null,"link_text":null,"link_url":null,"show_feature_image":false,"background_image_opacity":0.8,"should_show_feature_image_section":true,"feature_image_attributes":{"image_urls":{"default":"https://ksr-ugc.imgix.net/assets/011/900/169/0e9ebc83f4de290e25dce2ab91fb7058_original.jpg?ixlib=rb-..."}}}le-petit-matisse-imagine-create-sharehttps://www.kickstarter.com/discover/categories/art/mixed%20mediaFALSEFALSEfailed14159468771{"web":{"project":"https://www.kickstarter.com/projects/lepetitmatisse/le-petit-matisse-imagine-create-share?ref=discov..."}}1553domestichttps://www.kickstarter.com/projects/lepetitmatisse/le-petit-matisse-imagine-create-shareStoryRisks and challengesStory Why is everything out there so expensive? I'm sure you've considered buying that lovely beeswax crayon for your child before, but cringed on having to pay so much for it, right?  What about that non-nano face paint that is almost as expensive as high end make up (when all you get is 1/4 oz.)?! Yes, good quality natural and nontoxic raw materials cost more. But I'm here because I want to change, what you (the customer) has to pay to get these safer products!  I want YOU to be able to buy safer art supplies for your child without breaking the bank! By me being able to buy my raw materials to produce in a larger scale = less expensive for you.  Support my project and you will never have to think twice again before allowing creativity to stay alive in your child! All nontoxic, natural and specially formulated for the little ones.  Who is Le Petit Matisse? Le Petit Matisse is more than a brand.  In fact, he is an actual person. The little boy in our logo is my son, who's middle name is Matisse.  When my little Matisse was born, at only 26 weeks and 5 days, he was considered an extreme preemie.  But if you saw him now, almost five years later, you would never guess that!  I believe that it was not only my dedication as a mother that helped his development, but also the therapeutic powers of doing art!  He first experienced what it was like to get paint on his hands at only 14 months of age, and to this day he either paints, draw, or does both every day...simply because he LOVES art. Wouldn't it be great if every little kid can experience the benefits and joy of touching paint, holding a crayon (or even tasting it), squeezing some play dough with their tiny fingers... all of that without mommy or daddy worrying about it?Our Product is Born!It all started with me trying to make some stove top cornstarch paint that got moldy after two days, yuk!  But after getting tired of trying someone else's recipe, I created my own. By using only the best raw materials available and researching my now competitors to make my product have what theirs lacked,  I'm happy to report that I've achieved that (tons of moms and kids have told me so)!  Le Petit Matisse PAINTS - TRULY NONTOXIC & FUN TO USE!Unlike other paints that are advertised as nontoxic, our paints are all natural, long lasting and a pleasure to use! Pre-mixed: our paint comes ready to use, right out of the jar and it has a wonderful creamy consistency. Truly Natural: Le Petite Matisse tempera-stye paint is made with mineral pigments, NOT oxides. Our watercolors are made with fruit and vegetable extracts. Sorry Crayola, no neon colors for us! Long-lasting: Our tempera paint is long lasting even after it dries Natural Fragrance: No smelly chemicals in our paint!  All our natural paints are scented with REAL French Lavender essential oil to evoke relaxation and focus Le Petit Matisse PLAY CLAY and GLUE - GLUTEN FREE & AFFORDABLE. You'll no longer have to pay a higher price so that your little one with gluten sensitivity can play.  I developed our product with not only quality in mind, but with ALL children in mind.Le Petit Matisse BRUSHES - SUSTAINABLY HARVESTED & DEVELOPMENTALLY APPROPRIATE FOR YOUNG ARTISTSAll children benefit from both the sensory experience of finger-painting and, when they are older, the fine-motor benefits of using brushes. When they are ready to use a paint brush, children should use one that is appropriate to their developmental level.  I designed these anatomically correct paint brushes with just that in mind! Both brushes are handmade locally out of sustainably harvested and renewable poplar wood, making them durable and light weight; an eco-responsible choice for your little one's developing hands.Le Petit Matisse HAND POURED CRAYONS - ALL NATURAL & MADE FOR LITTLE HANDS. With only four ingredients, our crayons are sustainable, all natural and fun. No need to get out the dictionary to find out what's in them! Beeswax, non GMO soy wax, candellila wax, and mineral pigments. That's it!  The crayons come in two styles: The rocks of crayon are specially designed for little hands, and are a valuable tool in helping with pincer grasp.  The twist-up crayons are perfect for older kids, and awesome to take on tripsLe Petit Matisse APRONS - PERFECT FOR THE BUSY YOUNG ARTIST!Specially designed to grow with your little artist with an adjustable neck/waist strap and a handy front pocket to keep things like paint brushes and other art supplies.  All our aprons are locally hand cut and sewn, and made of organic cotton & hemp  blend fabric. Imagine . Create . ShareThe motto to our brand is just that.Three years ago I imagine a way for children to enjoy art without boundaries.  The boundaries of not knowing what's in your children's paint, for example.I then created our products (and our studio).I now would like to share with kids and parents all over! Now I Need a Bigger Space. HELP! For the past three years, I've been making ALL our products out of my tiny kitchen after everyone is asleep! Since I'm a clean freak (and to prevent any cross contamination), it's very time consuming to turn my kitchen into a lab/production room every time I have to make more products to be used at the studio, or to fulfill orders.Your help will enable our storage room to become a commercial grade production room! This alone will allow me to grow my business significantly over the next year, as I share this great product line with people every where.So here's the initial cost break down: Production room - $ 6 - 10k Bottle Fillers - $3k (https://www.youtube.com/watch?v=iAAJEytofkk) Dough mixer - $600 Dough cutter/rounder - $3k Raw materials in large quantities (25kg and up) - $250+ per ingredient Initial Packaging - $1,500 Dedicated Website - $1,500 ** For every $ we go above our goal, we will also be able to add the following:$270 - Stirring hot plate (for making crayons) each. We'd like to have six of them so we can make all six colors of crayons simultaneously. Right now I have one hot plate that was donated to me by a biotech company that was closing down shop$60 x 6 (colors)-  silicon mold for our crayons. Each color needs its own. right now I'm sharing one single mold for them all$1700 - Pay for booth at San Francisco's Green Festival this November. My first official trade show!Your help I will also make it possible for my products to become available in a store near you! My long term goal is to make sure products like mine are no longer a luxury, but the norm!  This is my way to contributing towards the next generation of Picassos, Matisses, Fridas and Monets. This project will only be funded if I reach my full goal!  So please share this page with all your friends.  Thank you for your pledge.The Rewards Our Twist up crayons. Great for trips! Our awesome glue. Did I hear collage?! Rocks of Crayon rock! Our Silky (and nice smelling) Young Artist Paint - for this campaign only available in the primary colors Gluten free play clay, yummm Water colors chubby brushes Press Risks and challengesSome of our raw materials are imported from France, so it is highly unlikely, but the customs officer may be having a bad day. That may delay the delivery of certain items. Luckily, I have a small inventory of my products already, so most of the orders will be fulfilled on time in case of any delays with my raw materialsLearn about accountability on KickstarterQuestions about this project? Check out the FAQReport this project to Kickstarter
1This is a photo book project of a minimum of 160 pages. Documenting abandoned businesses in the 159 counties of Georgia.{"id":280,"name":"Photobooks","slug":"photography/photobooks","position":5,"parent_id":15,"parent_name":"Photography","color":58341,"urls":{"web":{"discover":"http://www.kickstarter.com/discover/categories/photography/photobooks"}}}10USthe United States1441724086{"id":805003511,"name":"William Douglas","is_registered":null,"chosen_currency":null,"is_superbacker":null,"avatar":{"thumb":"https://ksr-ugc.imgix.net/assets/010/323/480/ec37215d681093cb951670a6e47b0eee_original.jpg?ixlib=rb-..."}}}USD$TRUEUSD1444321165FALSE 11500363171617 FALSE 1441729165{"id":2395298,"name":"East Atlanta","slug":"east-atlanta-atlanta-ga","short_name":"East Atlanta, GA","displayable_name":"East Atlanta, Atlanta, GA","localized_name":"East Atlanta","country":"US","state":"GA","type":"Suburb","is_root":false,"expanded_country":"United States","urls":{"web":{"discover":"https://www.kickstarter.com/discover/places/east-atlanta-atlanta-ga","location":"https://www.kicksta..."}}}Forgotten Pieces of Georgia (Canceled) {"key":"assets/012/246/439/3b5225688f99046a7b57e5f9fae80279_original.jpg","full":"https://ksr-ugc.imgix.net/assets/012/246/439/3b5225688f99046a7b57e5f9fae80279_original.jpg?ixlib=rb-..."}10{"id":2109982,"project_id":2109982,"state":"inactive","state_changed_at":1441724086,"name":null,"blurb":null,"background_color":null,"text_color":null,"link_background_color":null,"link_text_color":null,"link_text":null,"link_url":null,"show_feature_image":false,"background_image_opacity":0.8,"should_show_feature_image_section":true,"feature_image_attributes":{"image_urls":{"default":"https://ksr-ugc.imgix.net/assets/012/246/439/3b5225688f99046a7b57e5f9fae80279_original.jpg?ixlib=rb-..."}}}forgotten-pieces-of-georgiahttps://www.kickstarter.com/discover/categories/photography/photobooksFALSEFALSEcanceled14437018821{"web":{"project":"https://www.kickstarter.com/projects/805003511/forgotten-pieces-of-georgia?ref=discovery_category_ne..."}}10domestichttps://www.kickstarter.com/projects/805003511/forgotten-pieces-of-georgiaStoryRisks and challengesStoryI started this project after driving around Georgia shooting on weekend or class assignments while I was in college getting me degree in photography.I noticed as I traveled that there was a large amount of business that are now shuttered and a lot of them have closed because of the economic downturn of 2008. A lot of Georgia families have been affected by the changes in the economy and many of them lost everything they had, including not just their businesses but also their homes.It's very hard to drive around Georgia, seeing all of these businesses disappear and know these families are going through probably the worst circumstances in their lives. Their lives have been forever changed and not for the better. Some of these families had been in business for many years or even generations. Ken's Used Cars  The Citgo station which is the cover photo will be the download and print that is sent to supporters. The image will be available as canvas or metal (aluminum) prints in the list of rewards (your choice). These prints will be done through BayPhoto and will be limited in number and only available to KICKSTARTER supporters. Forgotten Collage All the images in the book and the prints will be watermark free I only have the water mark on the online versions.Stretch Goal #1If the project passes $2,000 I will include bonus images in the book of sunsets and other sights around Georgia like Tybee Island, Savannah and some other sights.Stretch Goal # 3If the project reaches $3,000, all supporters that pledged $5 or more will receive a downloadable copy of the book in PDF format for viewing on desktops, or tablets. The digital copy will be non-printable.If necessary, I will add more stretch goals should the need arise.You can view my work at my personal photography site  or on my Liam Photography site and also on my Forgotten Pieces of Georgia Facebook page.Risks and challengesThe risks and challenges for this project were mostly during shooting. Other than the page listing Kickstarter supporters and the bonus pages (if the project reaches it's stretch goals), the only things left to design are the book spine and dust jacket. I will have to wait until I know the exact length of the book since any bonus sections will affect the thickness of the book. The original book itself will be 160 pages. I have allowed time to completed the project and book for on time shipping.Learn about accountability on KickstarterQuestions about this project? Check out the FAQReport this project to Kickstarter
859Let's enable movement while upholding cultural beliefs, because all girls deserve to play. #UnitedWePlay{"id":263,"name":"Apparel","slug":"fashion/apparel","position":2,"parent_id":9,"parent_name":"Fashion","color":16752598,"urls":{"web":{"discover":"http://www.kickstarter.com/discover/categories/fashion/apparel"}}}38159USthe United States1470707412{"id":1913748268,"name":"ASIYAâ„¢ Modest Activewear","is_registered":null,"chosen_currency":null,"is_superbacker":null,"avatar":{"thumb":"https://ksr-ugc.imgix.net/assets/013/932/061/c5a2fa101310cc42278d9f83368e56fc_original.jpg?ixlib=rb-..."}}}USD$TRUEUSD1479398744FALSE 1250001961419297 FALSE 1476803144{"id":2452078,"name":"Minneapolis","slug":"minneapolis-mn","short_name":"Minneapolis, MN","displayable_name":"Minneapolis, MN","localized_name":"Minneapolis","country":"US","state":"MN","type":"Town","is_root":false,"expanded_country":"United States","urls":{"web":{"discover":"https://www.kickstarter.com/discover/places/minneapolis-mn","location":"https://www.kickstarter.com/..."}}}ASIYAâ„¢: Activewear Designed to Enable Muslim Athletes {"key":"assets/013/929/478/ae7dea7377039ea31f170778a14053d3_original.jpg","full":"https://ksr-ugc.imgix.net/assets/013/929/478/ae7dea7377039ea31f170778a14053d3_original.jpg?ixlib=rb-..."}38159.1999999999{"id":2631959,"project_id":2631959,"state":"inactive","state_changed_at":1470707412,"name":null,"blurb":null,"background_color":null,"text_color":null,"link_background_color":null,"link_text_color":null,"link_text":null,"link_url":null,"show_feature_image":false,"background_image_opacity":0.8,"should_show_feature_image_section":true,"feature_image_attributes":{"image_urls":{"default":"https://ksr-ugc.imgix.net/assets/013/929/478/ae7dea7377039ea31f170778a14053d3_original.jpg?ixlib=rb-..."}}}asiyatm-activewear-designed-to-enable-muslim-athlehttps://www.kickstarter.com/discover/categories/fashion/apparelTRUETRUEsuccessful14793987441{"web":{"project":"https://www.kickstarter.com/projects/1913748268/asiyatm-activewear-designed-to-enable-muslim-athle?r..."}}38159.1999999999domestichttps://www.kickstarter.com/projects/1913748268/asiyatm-activewear-designed-to-enable-muslim-athleStoryRisks and challengesStoryDid you know that the participation rate of Muslim girls in sports is about half that of their peers? One of the barriers to participation is the clothing worn for religious and cultural reasons. We aim to change that. ASIYAâ„¢ is culturally-appropriate activewear. Our innovative fitness fashions and fabrics are easy to move in, to play in, to compete in. ASIYA honors and encourages Muslim women of all ages—young girls, tweens, teens, mature women—to experience a new level of confidence, cultural integrity, comfort, and health. Sports participation is important for building lifelong leadership skills and self-confidence. In fact, in one survey it was discovered that 94% of women executives participated in sports (Source: EY Women Athletes Business Network & espnW, October 2014). We want all girls to have the opportunity to establish healthy lifestyles and build a foundation for future success. Our first line of products — sports hijabs — will enable Muslim girls and women to be physically active and participate in sports while upholding their religious and cultural beliefs. And if you don't wear a hijab, you can still support this effort to empower more young women to play (and win).     ASIYA is creating three styles of sports hijabs to meet the specific needs of the Muslim female athletes who inspired and designed them. ASIYAâ„¢Lite and ASIYAâ„¢Sport are ideal for sports practice or games, with the ASIYA Sport design tailored close to the neck and intended to tuck inside a uniform to avoid inadvertent snags or grabs from other players. ASIYAâ„¢Fit is ideal for working out with additional coverage in the front. Designed to stay secure without the need for pins, our stretchy one-size-fits-all sports hijabs have a unique head-band feature inside to hold the hijab tight to the base of the neck. Each style is made from our unique sweat-wicking and breathable soft mesh ASIYAâ„¢Cool fabric technology, so athletes can stay cool and comfortable while dressing modestly. Finally, a line of sports hijabs to help Muslim girls and women alike enjoy all the benefits of playing sports. We Believe In Modesty — Clothing can represent your beliefs and who you are as a person. We Believe In Freedom — Clothing should enable your endeavors, not be a barrier.We Believe In The Power Of Sport — Participation in sports helps set girls up for success as students, community members, and future leaders.We are in the midst of worldwide dialogue around topics like immigration, what women should and shouldn’t wear, and overall racial equality, questioning how we honor freedom of expression and inclusion.  At the same time, amazing Muslim female athlete role models are emerging as international sports organizations are lifting their bans on headwear to allow Muslim women to compete in the hijab. Earlier this year we even saw the first-ever US Olympian compete in a hijab, silver medalist Ibtihaj Muhammad (who reportedly chose to pursue fencing because the helmet covered her hair and neck). We want to join these amazing athletes as champions of inclusion and empowerment. The idea for ASIYA began in the Brian Coyle Community Center gym, in the Cedar-Riverside neighborhood of Minneapolis, where Fatimah Hussein has been helping young Muslim girls gain access to sports and physical activity for the past decade. She founded a non-profit program — G.I.R.L.S. (Girls Initiative in Recreation and Leisurely Sports) — to create girls-only gym time several nights a week.  As the girls gained self-confidence and a love of sports, they wanted athletic uniforms and apparel that let them compete in public while upholding their religious and cultural beliefs. In a collaboration with the Cedar-Riverside community and the University of Minnesota, prototype basketball uniforms were developed in 2015, but Fatimah soon realized that a versatile line of sports hijabs — something that wasn’t readily available in the U.S. or anywhere — would create many more opportunities for girls to participate and grow through team play. That realization inspired several generations of prototypes that were tested by the girls to optimize for fit, fabric, and performance. Experienced marketer Jamie Glover, who credits sports for helping to shape who she is today, joined Fatimah to build a brand so they could meet this need beyond Minneapolis. Watch the girls run with the World Champion Minnesota Lynx in this recent WCCO-TV story. Our brand name ASIYA (AH-see-ah) was selected because it’s the name of a highly revered woman from Islamic history, Asiya bint Muzahim, who is known for being courageous and standing up against injustice. We thought she was the ideal role model and champion for our cause. The young girls you see in this campaign have been an integral part of the product design process and they can’t wait for finished production versions of these sports hijabs to be ready for action. That’s where you come in...    We need Kickstarter funding so we can proceed with manufacturing our first line of sports hijabs for distribution around the world.   This campaign will also help us get the word out to the broader community and hopefully inspire them to support all girls in their desire to play, to be part of a team, and to reach their full potential through sports and physical activity. Purchasing fabric Cutting+Sewing manufacturing (we're proud to be Made in the USA!) Outfitting athletes with sports hijabs so they can play to their potential Whether you want to pre-order a hijab or just help this mission become a reality, we have a reward option for you! All three styles of sports hijabs are available for pre-order through this campaign in your choice of color — white, black, navy, or grey (with more custom colors also available). You can have a single hijab in any style for $25 (that’s 30% off the retail price), or you can opt for a dual-pack of hijabs in different colors and/or styles for $45 (that’s 35% off the retail price). Great for home and away game color options or having different styles for different uses. If you want a dual-pack of hijabs AND the rest of our ASIYA gear available through this campaign (long sleeve shirt, drawstring bag, headband), there’s an option for that as well at the $100 level. And we have an exclusive offer (max of 10) where you can customize the design of any of our sports hijab styles. Print whatever pattern you want on the fabric or choose colors to match your team. You choose, we’ll make it happen! For campaign backers who want to support this effort but do not have a need for a sports hijab, we have several reward tiers where your contribution helps sponsor a young Muslim athlete. For every ten $25 contributions (or every five $50 contributions) a promising athlete will be outfitted with an ASIYA hijab and gear. And as a thank you, we’ll send you some fun ASIYA-branded gear — either a headband or drawstring bag at the $25 level, or a high-performance long sleeve activewear shirt for $50. You can also sponsor an athlete on your own at the $250 level, or a full team for $1,000.  And at $2,500, we’ll outfit a full team and “kickstart” their season by paying their league/team participation fees while also working with them to test and develop our next line of modest activewear products.    Fatimah Hussein, CEO, Co-Founder  As a Licensed Graduate Social Worker, Fatimah has been dedicated to serving her community in Minneapolis for many years. Recognizing the need for girls-specific physical activities in the Muslim community specifically, she established the non-profit organization Girls Initiative in Recreation and Leisurely Sports (G.I.R.L.S.) in 2008, which provides resources and gym access for girls. Now she’s driven to make sure every Muslim girl who wants to play sports is able to play sports and gain all the lifelong benefits without needing to compromise her cultural beliefs.  Jamie Glover, President & COO, Co-Founder  Growing up playing competitive sports through college, including being named All-American Honorable Mention in volleyball, Jamie strongly believes that the court and field are critical classrooms for learning leadership, teamwork, and lessons like how to win with grace and lose with dignity. After ten years managing marketing roles for major brands, she is excited about working on this social venture, using business for good and making a meaningful impact in the world. Jan-March 2016: Product Design - fit & style  March-May 2016: Fabric Sourcing - evaluated over 80+ fabrics!  May-June 2016: Prototype Development  July-Sept 2016: Testing and Business Planning  Oct-Nov 2016: Kickstarter!  Nov 2016 -Jan 2017: Manufacturing  Feb 2017: Fulfillment - rewards received by the end of February!  March 2017: Online sales of sports hijabs   April-June 2017: Development of next line - team uniforms & activewear! Please support this campaign to help us create innovative activewear that is easy to move in, to play in, to compete in, and ultimately honor and encourage Muslim women of all ages to experience the benefits of playing sports while upholding their religious and cultural beliefs. Thank you!     Risks and challengesWe are working with a new manufacturer, for the first time, so there is a potential for delays in the production process. We will make every available effort to deliver all rewards by the fulfillment deadlines and we promise to notify all of our backers if there is reason to believe there could be a delay.Learn about accountability on KickstarterQuestions about this project? Check out the FAQReport this project to Kickstarter
SandSlinky
7 - Meteor

It's not letting me do this either, apparently. I've attached a screenshot, which hopefully gives a bit of an impression, and it has an example of a blurb highlighted. I hope this helps?

AbhilashR
15 - Aurora
15 - Aurora

Thank you for attempting to share data in different forms. I am not sure why your excel files weren't being accepted. I looked at your sample image and feel the approach suggested in the attached workflow might be helpful. 

 

approach 1 - does a cross join between the two datasets and then uses the Contains function to do the lookup. It isn't the most efficient way to do things given you tend to increase the number of records only to filter it downstream, but sometimes it is a good way to start or at the very least get your work done.

 

approach 2 - using the Find Replace tool. This tool was meant for cases like these where the user has reference data and wants to compare it with the base universe. It does the heavy lifting of joining the appropriate rows across the two datasets, making it easy for you to compute weight/score.

AbhilashR_0-1590437284537.png

I hope one of these two approaches work for you,

SandSlinky
7 - Meteor

I tired using the second approach, but since I am searching in two separate fields and I treat them both a little differently, I will need to use two separate "Find Replace" tools and follow them up with two separate "Formula" tools right? Like I tried doing here:

SandSlinky_0-1590447440769.png

 

But how do I follow up on this then? How do I add these results together, as I cannot join two separate formulas into one summarize function, which I need to calculate the sum of the scores. It attached this preliminary workflow as well.

AbhilashR
15 - Aurora
15 - Aurora

You can place the consecutive to do multiple lookups. 

AbhilashR_0-1590452793105.png

 

 

SandSlinky
7 - Meteor

Thanks again for your help.

 

I tried incorporating this structure into my workflow, please find it attached. The problem I'm having now is that it seems to only count the search terms in the story if a search term appears in the blurb. As you can see in this screenshot, all entries with scores in Found_Story also have scores in Found_Blurb (there aren't many) and all others are empty, even though I know others definitely contain relevant words as well.

I think I also found out why the output in the blurb is so much larger than it should be; before, I use the "Text to Columns" feature to split the story by sentence, so I can later count the total number of sentences in the story. But I guess it then duplicates the "blurb" field for each sentence in the story and then adds them all together. I thought I could maybe solve this by first performing the search function in the blurb and then splitting the story, but that hasn't worked either. If I can solve these two issues, everything should be perfect. I have attached my workflow.

SandSlinky_0-1590491872905.png

 

deviseetharaman
11 - Bolide

@SandSlinky,

Please try the below formula 

Found_Blurb - Weight+3

I guess with Find and Replace tool, the weight should be already there.

 

could you please write the excel file to yxdb using output tool and try sending it. If the size is big use a sample tool and give first 1000 rows

SandSlinky
7 - Meteor

@deviseetharaman, thanks for the suggestion. I tried that, but then I don't seem to get any results:

SandSlinky_0-1590499370749.png

 

I have attached the yxdb file, let's hope this works.

deviseetharaman
11 - Bolide

Hi @SandSlinky 

 

I have made some changes. Please generate the report and check

 

sum_blurb = sum_blurb/countSentences. Also bringing the testsearch to result to compare.

SandSlinky
7 - Meteor

@deviseetharaman 

Oooh, why didn't I think to do that! That works, thank you so much! And @AbhilashR as well!

I don't have much experience with Alteryx, so this was pretty difficult for me, sorry for that. But I finally have my data now.

Thanks again!

Labels