I have a question. If I have a larger dataset, let`s say 10k responses, and lets say 10 keywords, the comparison table out of a sudden will jump from 10k to 100k. This can get nasty for performance quite fast. Can I somehow just relate both tables without unpivoting the keywords? I hope I was clear with the question, thank you for the very interesting material.
Very helpful thanks so much! Quick question: one of my keywords is "Dust" and the query is matching records containing the word "Industry", any tips on how to address this? Thanks again :)
i did the same for my work. But it's not counting correctly. for example, it counts much 18 "1"s while there are only 2 "1". it counts 36 while there are 6 "1". Any idea what is wrong? Thank you!
I tried this method for a large dataset it's generating too many duplicate values and while sorting it gives me error as "can't convert the value # (2022,12,02) to date" Please help
Lol, you say "without further ado, let's get started." THEN you introduce yourself and do more marketing of your channel, etc. I'm not sure you know what "without further ado" means.
that's exactly what i need for my work! thank you !
I have a question. If I have a larger dataset, let`s say 10k responses, and lets say 10 keywords, the comparison table out of a sudden will jump from 10k to 100k. This can get nasty for performance quite fast. Can I somehow just relate both tables without unpivoting the keywords? I hope I was clear with the question, thank you for the very interesting material.
Did you figure out how to do it?
Great video. This is a clear way to do cartesian matching.
Thanks for watching!
This is very helpful!!! I can now use this in certain dashboards. Thanks!! U're the best.
Thank you for making this channel, it's very Useful
Very Helpful!! Thank you!!
Very helpful thanks so much! Quick question: one of my keywords is "Dust" and the query is matching records containing the word "Industry", any tips on how to address this? Thanks again :)
Same question here!
How about adding a space before and/or after the keyword?
I had a similar problem and added a space before. As long as the word is not the first of the sentence, it should work.
Great video! I am wondering if you know of a way to make this an exact match?
Thank you for the great video!
No worries!
Hie i have a question on 5:00 where did you clicked to edit ? i did not found it
i did the same for my work. But it's not counting correctly. for example, it counts much 18 "1"s while there are only 2 "1". it counts 36 while there are 6 "1". Any idea what is wrong? Thank you!
I tried this method for a large dataset it's generating too many duplicate values and while sorting it gives me error as "can't convert the value # (2022,12,02) to date"
Please help
Life saver
Lol, you say "without further ado, let's get started." THEN you introduce yourself and do more marketing of your channel, etc. I'm not sure you know what "without further ado" means.