Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Date | Date_KEY | CCY_RATE |
---|---|---|
31/12/2011 | 31/12/2011 | 89.9457 |
1/1/2012 | 1/1/2012 | |
2/1/2012 | 2/1/2012 | |
3/1/2012 | 3/1/2012 | 90.1315 |
4/1/2012 | 4/1/2012 | 90.2564 |
5/1/2012 | 5/1/2012 | |
6/1/2012 | 6/1/2012 | |
31/12/2011 | 31/12/2011 | 89.9457 |
1/1/2012 | 1/1/2012 | 89.9457 |
2/1/2012 | 2/1/2012 | |
3/1/2012 | 3/1/2012 | 90.1315 |
4/1/2012 | 4/1/2012 | 90.2564 |
5/1/2012 | 5/1/2012 | 90.2564 |
6/1/2012 | 6/1/2012 | |
31/12/2011 | 31/12/2011 | 89.9457 |
1/1/2012 | 1/1/2012 | 89.9457 |
2/1/2012 | 2/1/2012 | 89.9457 |
3/1/2012 | 3/1/2012 | 90.1315 |
4/1/2012 | 4/1/2012 | 90.2564 |
5/1/2012 | 5/1/2012 | 90.2564 |
6/1/2012 | 6/1/2012 | 90.2564 |
Hi All,
I am also looking for the same. Any update from anyone on this?
tmp:
LOAD
Date, Date_KEY, CCY_RATE
FROM [http://community.qlik.com/thread/60912] (html, codepage is 1252, embedded labels, table is @1)
where RecNo()<=7 ;
table:
NoConcatenate load
Date, Date_KEY, CCY_RATE,
if(len(trim(CCY_RATE))=0, peek(NEW_CCY_RATE), CCY_RATE) as NEW_CCY_RATE
resident tmp
order by Date;
DROP Table tmp;
Hi,
tst:
LOAD * INLINE [
Date, key, rate
01.02.2014, 1, 23.44
01.03.2014, 2
01.04.2014, 3
01.05.2014, 4, 21.33
01.06.2014, 5, 20.111
];
NoConcatenate
test:
LOAD
Date,
key,
if(isnull(rate) or rate='', peek(rate),rate) as rate
Resident tst;
drop table tst;
works too.
Is it necessary to give new alias?
Andrei