Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
I have following problems:
T1 | Seller |
---|---|
1 | A |
2 | |
3 | C |
T2 | Seller |
---|---|
qw | A |
as | B |
yx |
T1 | T2 |
---|---|
1 | qw |
2 | as |
3 | yx |
I want to show all the Seller: 1,2,3 WITHIN to fill the missing information like:
a) if I click B, it only shows "as", not "2" from T1
so how can I tell Qlik in Script, that:
If no seller in T1, look in T2 ?
and reversed ..
Like:
If T1 has not Seller, so look in T2 and summit that 2=as=B -> 2=B
or
If(Seller not exists in T1,
I am sorry for my english
Hi Thomas, maybe helps if you can assing in script T1 and T2 for each seller, this way will be easier to get the associated value, you can do this:
// ***** Original data *****
T1:
LOAD * Inline [
T1,Seller
1,A
2,
3,C
];
T2:
LOAD * Inline [
T2,Seller
qw,A
as,B
yx
];
Relations:
LOAD * Inline [
T1,T2
1,qw
2,as
3,yx
];
// ***** Creating Mapping *****
Map_T1:
Mapping LOAD T1,Seller Resident T1;
Map_T2:
Mapping LOAD T2,Seller Resident T2;
MAP_RelationsT1_T2:
Mapping LOAD T1, T2 Resident Relations;
MAP_RelationsT2_T1:
Mapping LOAD T2, T1 Resident Relations;
// ***** Create table by seller with T1 and T2 *****
Result_tmp:
NoConcatenate LOAD T1,
If(IsNull(Seller) or Seller='', ApplyMap('Map_T2', ApplyMap('MAP_RelationsT1_T2', T1)), Seller) as Seller
Resident T1;
Concatenate LOAD T2,
If(IsNull(Seller) or Seller='', ApplyMap('Map_T1', ApplyMap('MAP_RelationsT2_T1', T2)), Seller) as Seller
Resident T2;
Result:
NoConcatenate LOAD Seller, MinString(T1) as T1, MinString(T2) as T2 Resident Result_tmp Group By Seller;
DROP Tables T1, T2, Relations, Result_tmp;