topic Re: Help to do data model for below logic. in QlikView

Help to do data model for below logic.

debabrata_sahoo — Wed, 25 Nov 2020 16:16:04 GMT

Find the below 2 table and let me help how will i do data model. In Front end I need to show Sum(weight) with using filter SHC GROUP CODE .

Table-1(FACT)

Table-2

cbaqir — Thu, 20 Jun 2019 22:21:40 GMT

I think you are asking how to join the tables. You can use subfield(SHC,',') on table 1 to parse out each.

Table1:

Load

AWB,

subfield(SHC,',') as SHC,

WeightKg

FROM

Table1 Source;

Table2:

Load

SHC,

[SHC GROUPCODE]

FROM

Table2 Source;