How to track records that have changes in some columns.

[jim_chan]

Hi guys,

I have posted up this question b4. but no answer yet.

For example . i have 2 years of data loaded in. 2015-2016.

Take ID 003 as example: in year 2015, category column is charlie and locatin column is shop

in year 2016, ID 003, category changes to delta and location change to Toilet.

I need a text object to count all these ID that has changed. and a table box that show which ID has changes in category and location column.

[jim_chan]

Sunny bro,

I managed to get the those record ID which have changes in fields.

However i tried to extend the pivot table with few more fields, there comes the problem, duplicated.  i have sent u a scramble qvw file.

[jim_chan]

Dear Sunny,

I would need to add in few more columns

Previous Location | Current Location | Previous Category | Current Category

How to create the - Previous column?

Rgds

jim