Problem with scripting

[josephinetedesc]

Hi All

I would like to have a table of all (parent) records with their  (child) notes.

Doing it my way (as shown below )I get into a problems:

For exmaple

rec1 - does not have a note and I want to show that

rec2 - has 2 notes I do not want to show the line which shows that it does not have a note.

What I want is:

if a Record has a note - show this

if a Record has not got a note - show this

if a Record has a note ignore the the indicator that says no note

Thank you for your help

Jo

[jyothish8807]

Hi Joseph,

In the below example which value should be considered as 'no note' ?

Could you please share the expected output clearly in the required format ?

[josephinetedesc]

Hi KC

the lines with the yellow highlight are the problem:

In excel I used the following formula:

if the cell below is the same as the cell above and if the cell is blank - "delete" and then manually delete that line

'=IF(E1987=E1986,IF(ISBLANK(F1987),"delete","ok"))

thank you

Jo

[Anil_Babu_Samineni]

In Qlik also we can use like

=If(Field1=Field2, If(IsNull(Field1), 'delete', 'ok'))

[jyothish8807]

Hi Joseph,

Please try this aswell.

Load
Record,
Note,
if((Record=Previous(Record) and Note='nx') or (RowNo()=1 and Note='nx'),'',Note) as New_Note;

LOAD * INLINE [
Record, Note
rec1, nx
rec2, notea
rec2, noteb
rec2, nx
rec3, notec
rec4, noted
rec5, notee
];

[josephinetedesc]

Hi

on the same line - but I need to check the line above!

Jo

[jyothish8807]

Hi,

I am checking the above value using 'previous' function in script.