Comparing 4 columns having a unique column

[akash_singhal]

I have a table with 5 columns Name, Date, ID, Rate, Type

Now I want that whenever column 'Name', 'Date' & 'ID' is selected among all the other columns and they have the same 'Rate' then change 'Type' to 'Unsure'

Name	Date	Id	Rate	Type
John	10th Aug	1122	1	True
Ron	15th Aug	1344	1	False
Steve	13th July	1122	5	False
John	15th Sept	2113	3	False
Molly	2nd June	4841	1	True

Result:

Name	Date	Id	Rate	Type
John	10th Aug	1122	1	Unsure
Ron	15th Aug	1344	1	Unsure
Steve	13th July	1122	5	False
John	15th Sept	2113	3	False
Molly	2nd June	4841	1	Unsure

Thanks!

[Brett_Bleess]

This would need to be done in the load script which is going to be fairly complex task if you are new to things.  If you can attach what you have in the way of QVW file, someone may be willing to have a look and help out, but expecting someone to write everything for you is not something I would expect to happen.  

Basically, you would need to load the data, group it into the correct order using Group by or Order by function and then do another pass through looking for your sequence and modifying the field data if things are true etc.  

Here is a link to the Design Blog area you can use to search posts there, they are mostly how-to, so may be of some help to you in sorting things out on your own.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett