Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Incremental load

Hi All,

I have an one FACT TABLE,

My FACT TABLE don't have the "UNIQUE KEY" and "DATE " fields.

Now I want to do INCREMENTAL LOAD, How can I do that ?

please help me out this issue..

Thanks

Venkey

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: Incremental load

Then it won't be possible to identify changed records. Only new records can be detected.

MyTable:

LOAD ...lot of fields..., hashkey_field FROM HistoricalData.qvd qvd();

CONCATENATE (MyTable)

LOAD ...lots of fields... , autonumberhash256( ...lots of fields...) as hashkey_field

WHERE NOT Exists( hashkey_field, autonumberhash256( ...lots of fields...) );

SQL SELECT ...lots of fields... FROM MySQLDatabase.MySQLTable;


talk is cheap, supply exceeds demand