Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone help me please?
I am trying to compare two file fields value with same field name(comparison for two months) in script.
Can some one suggest best way? Is it possible?
FOR i = 1 to NoOfFields('T')
Concatenate
Fields:
LOAD
// FieldName($(i),'New') as FieldName
FieldName($(i),'T') as F,
FieldValue($(i),'T') as v,
//FieldValue(FieldName($(i),'T')) as F2,
//if(FieldName like FieldName($(i),'New') and FieldValue=FieldValue,'Match','Others') as t2,
if(WildMatch(FieldName($(i),'T'), FieldName($(i),'T2')),'Match','Other') as f1,
if(Match(FieldValue($(i),'T'),FieldValue($(i),'T2')),'Match','Other') as f3
AutoGenerate 1
;
NEXT I
I tried field value but it is not working.
Hi,
I think your script seems to be fine for me. May be you can try to change the "Next i" ( In your code shows capital letter "I" - I believe this is not a typo)
FOR i = 1 to NoOfFields('T')
Concatenate
Fields:
LOAD
// FieldName($(i),'New') as FieldName
FieldName($(i),'T') as F,
FieldValue($(i),'T') as v,
//FieldValue(FieldName($(i),'T')) as F2,
//if(FieldName like FieldName($(i),'New') and FieldValue=FieldValue,'Match','Others') as t2,
if(WildMatch(FieldName($(i),'T'), FieldName($(i),'T2')),'Match','Other') as f1,
if(Match(FieldValue($(i),'T'),FieldValue($(i),'T2')),'Match','Other') as f3
AutoGenerate 1;
NEXT i
Hi,
As suggested by settu_periasamy change NEXT I to NEXT i.
Qlikview is Case sensitive Capital I and Small i is not the same.
Regards,
jagan.
I cannot see capital "I" in my script. I am using only "i".
That is already small i.
Copy your posted Script (In the first post), then check, it shows capital Letter 'I'.
See this..
not I any more.
T:
LOAD Name,
total,
'table' as type
FROM
(ooxml, embedded labels, table is Sheet1);
//Concatenate(T)
QUALIFY *;
UNQUALIFY Name;
//left join(T)
T2:
LOAD Name,
total,
'table2' as type
FROM
(ooxml, embedded labels, table is Sheet1);
//
UNQUALIFY *;
Name | total |
a | 20 |
b | 20 |
c | 30 |
d | 50 |