Qlikview Script If - Create new fields

[alexandermllr]

Hello,

I want to create a new field, when 2 fields have the same content.(order by Key)

Attached a example file.

I hope someone can help me

Thanks!

[ahaahaaha]

Hi,

May be like this

Table1:

Directory;

LOAD Key,

    Start,

    End,

    Description,

    value

FROM

CH02_20170712_160633.xls

(biff, embedded labels, table is Sheet1$);

Left Join

LOAD

Key,

End,

value,

If(Count(Key)=2, 'D', 'A') as NewField

Resident Table1

Group By Key, End, value;

Result

Regards,

Andrey

[ahaahaaha · Accepted solution]

Example at attached file

[alexandermllr]

Thank you so much!