This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Please help me on below scenario.
we have raw data like below:
Result: Need STATUS as New Status column if ID and NAME is same.
Use this pattern:
DATA:LOAD ID, NAME, D, STATUS as TSTATUSFROM ....;
JOIN(DATA)LOAD ID, NAME, TSTATUS as STATUSWHERE Len(TSTATUS) > 0;
DROP Field TSTATUS;
This assumes that there is never more than one instance of ID and NAME with a status. If that is not a safe assumption, then use this for the join instead:
JOIN(DATA)LOAD ID, NAME, MaxString(TSTATUS) as STATUSWHERE Len(TSTATUS) > 0GROUP BY ID, NAME;
View solution in original post
Answer here - https://community.qlik.com/t5/QlikView-App-Development/Need-Help/m-p/1658776/highlight/false#M448554