Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
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