topic Re: join between 2 Queries with like condition in QlikView

join between 2 Queries with like condition

amiroh81 — Wed, 18 Apr 2018 07:03:02 GMT

Hello everyone,

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.

For example:

sql:

inline

join table

Thanks in advance

isorinrusu — Wed, 18 Apr 2018 07:18:32 GMT

Hi Amir,

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 example:

for each vGroupType in FieldValueList('group type')

Grouping:

Load type,

count,

'$(vGroupType)' as GroupType

Resident sql where wildmatch(type,'$(vGroupType)*')>0;

next;

Drop table sql;

Left Join (Grouping)

Load "group type" as GroupType,

"group number"

Resident inline;

Drop table inline;

That should work.

Regards,

Sorin.

amiroh81 — Sun, 22 Apr 2018 04:17:55 GMT

thank you very much!

amiroh81 — Sun, 22 Apr 2018 10:39:23 GMT

Hi ,

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?

Thanks