Need to create a new field with values New, Existing

[MS90]

In qliksense I am receiving new record ids  every day we get new records, i need to create column showing values 'New','Existing' .

As my data model is complex I can't make change in my existing script and also I can't rely on my date field

 In table chart  for Record ids column i need to show whether they are New or existing record 

The Record ids column after loading data I did some calculation and final Record ids which meets requirment I am showing in Table 

[marksouzacosta]

That sounds like a problem that can be solved with an incremental load process.
Will be very challenging to add this feature you are asking without changing your script. Can you please explain how are you loading the data in your application? Also, is binary load a possible alternative?

[MS90]

@marksouzacosta 

Maintable:

Load

OrderNo,

Score,

Date,

Otherfields

From lib maintable.qvd(qvd);

DerivedTable:

Load

If (score>60,OrderNo)as OrderNo_Report

Resident Maintable;

RatingTable:

Load

OrderNo,

Rating,

Otherfields

• From lib RatingTable.qvd(qvd);

I am daily sendding a report based on OrderNo_Report and Rating>70 ,now I need to add a field in that report showing values 'LatestRecord','Existing'.

I can't reliable on date field because there are more than one date fields and data may updated from any one after daily load.

I need to show records differentiate based on order no only.

I can't use binary load and it is complex data model