Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

need a help in qlik requirement

Hi All 

i have  two tables like below  

yesterday:

record id

1

2

3

4

today:

record id

1

2

3

4

5

6

expected output :

record id ,tag

1, old record

2, old record

3, old record

4,old record

5,new record

6,new record

can u please help me with this

 

thanks in advance

regards

siva

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: need a help in qlik requirement

Hello Siva,

 

Basically, that's a question for 'Incremental load' in qlikview.

Which can be easily achieved with the Exists() function.

Example script you can plug and play:

 

OldSource:
LOAD * Inline [
ID
1
2
3
4
];

JOIN (OldSource)
LOAD
'old record' as tag
AutoGenerate (1)
;


NewSource:
NoConcatenate
LOAD * Inline [
ID
1
2
3
4
5
6
]
WHERE NOT Exists(ID)
;

JOIN (NewSource)
LOAD
'new record' as tag
AutoGenerate (1)
;

Concatenate(OldSource)
LOAD
ID,tag
Resident NewSource;

DROP TABLE NewSource;

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: need a help in qlik requirement

Hello Siva,

 

Basically, that's a question for 'Incremental load' in qlikview.

Which can be easily achieved with the Exists() function.

Example script you can plug and play:

 

OldSource:
LOAD * Inline [
ID
1
2
3
4
];

JOIN (OldSource)
LOAD
'old record' as tag
AutoGenerate (1)
;


NewSource:
NoConcatenate
LOAD * Inline [
ID
1
2
3
4
5
6
]
WHERE NOT Exists(ID)
;

JOIN (NewSource)
LOAD
'new record' as tag
AutoGenerate (1)
;

Concatenate(OldSource)
LOAD
ID,tag
Resident NewSource;

DROP TABLE NewSource;

View solution in original post