Discussion Board for collaboration on QlikView Scripting.
Could you help me with this issue:
I have two tables:
Sweater for girls Green
Bag Orange apple
The result I'm looking for after comparing these tables would then look like this:
Sweater Green for girls
Which is the best way to do it?
Go to Solution.
Please find QVW with solution attached.
Ksenia, if this is, in fact, the full extent of the problem, just code it manually using substringcount. For example:
) as Field2
If your real data is more extensive (as I'm guessing is the case), take a look at Rob Wunderlich's QlikView Cookbook. Specifically, the mappingWithWildcards.qvw example.
Thanks for your answer. You are right, it is a only simple example, i have more extensive data and it may change.
Thanks for advice, i'll take a look this book surely!
Hi Daniel! Thank you! I like it!