Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandermllr
Creator
Creator

Qlikview Script If - Create new fields

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!

1 Solution

Accepted Solutions
ahaahaaha
Partner - Master
Partner - Master

Example at attached file

View solution in original post

3 Replies
ahaahaaha
Partner - Master
Partner - Master

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

1.jpg

Regards,

Andrey

ahaahaaha
Partner - Master
Partner - Master

Example at attached file

alexandermllr
Creator
Creator
Author

Thank you so much!