topic Mapping between two table based on predefined wildmatch rules in data in QlikView

Mapping between two table based on predefined wildmatch rules in data

jerryyang756 — Sat, 16 Nov 2024 01:35:04 GMT

Hi all,

I have two table as given below

Table: Wire Groups

Here wild match condition is already written

Table: Usage Details

The 'usage detail' contains string defined in the above table in wildmatch rule. I have to map these two table and fill the 'Group' data from 'Wire Groups' table.

Re: Mapping between two table based on predefined wildmatch rules in data

sumanta1234 — Tue, 07 Jan 2020 11:54:33 GMT

Hi Pritam,

Please use the below script:

TABLE:
LOAD *,
MID(COND,1, LEN(COND)-2) AS CONDITION;
LOAD
Group,
MID(SUBFIELD([Wildmatch Condition],','),3) AS COND
FROM [C:\Users\sumantakm215\Downloads\Data.xlsx] (ooxml, embedded labels, table is [Wire Groups]);
JOIN(TABLE)
LOAD
[Usage Detail]
FROM [C:\Users\sumantakm215\Downloads\Data.xlsx] (ooxml, embedded labels, table is [Usage Detail]);

NOCONCATENATE
NEW_TABLE:
LOAD *
RESIDENT TABLE
WHERE WILDMATCH([Usage Detail],'*' & CONDITION & '*');

DROP TABLE TABLE;

Re: Mapping between two table based on predefined wildmatch rules in data

Kushal_Chawda — Tue, 07 Jan 2020 12:47:46 GMT

Please refer my reply in below thread. It looks similar to what you want

https://community.qlik.com/t5/New-to-QlikView/Requaried-Mapping-in-bucket-using-wild-search-of-qlikview/td-p/1663257

Re: Mapping between two table based on predefined wildmatch rules in data

Brett_Bleess — Mon, 10 Feb 2020 20:52:11 GMT

Did either of the two posts you received get you what you needed to solve your issue? If so, do not forget to return to the thread and use the Accept as Solution button on the post that helped the most. If you did something different, please consider posting that info and then use the button on your post to mark it as the solution. If you are still needing help, please leave an update, as you are unlikely to get further help unless you update things.

Regards,
Brett