Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
See sample screen shot of data below:
If the ACCOUNT field's left 2 digits start with 10, I would like to tag both of the lines related to this JRN ENTRY as 'FLAG'.
Any help would be greatly appreciated.
Thank you,
Steven
Basically the same as in SQL except Qlik Sense uses field names to do the joining instead of using an ON syntax.
Table1:
Select * From A;
Left Join (Table1)
LOAD
JRNL_ENTRY
'Treasurey' as TREASURY_FLAG
RESIDENT
Table1
WHERE
Left(ACCOUNT,2)='10'
Create an extra field when you load the data:
LOAD
...some fields...,
If(Left([ACCOUNT,2) = '10', 1,0) as FLAG,
...some more fields...
FROM ...source_table... ;
Basically the same as in SQL except Qlik Sense uses field names to do the joining instead of using an ON syntax.
Table1:
Select * From A;
Left Join (Table1)
LOAD
JRNL_ENTRY
'Treasurey' as TREASURY_FLAG
RESIDENT
Table1
WHERE
Left(ACCOUNT,2)='10'