Discussion Board for collaboration related to QlikView App Development.
I try to join between SQL query and inline when the join I want to execute will be provided that the inline data will be like the number in SQL.
Thanks in advance
One way to solve it is through an iteration on each "group type" value and using the Wildmatch or SubStringCount functions, building it step by step.
for each vGroupType in FieldValueList('group type')
'$(vGroupType)' as GroupType
Resident sql where wildmatch(type,'$(vGroupType)*')>0;
Drop table sql;
Left Join (Grouping)
Load "group type" as GroupType,
Drop table inline;
That should work.
View solution in original post
thank you very much!
While I was trying to implement the solution (working properly) I encountered another problem.
You can see that the prefix of the first and third lines is the same prefix but it is about two different group number.
Is it possible that the join between the two queries can be performed according to the correct prefix?