Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI ,
I have one problem to do in qlikview .if any one knows pls help me.
this is the problem;
source data:
document id | broker name | serial no | created on |
001 | chandu | 1 | 16-9-2012 |
001 | 2 | 16-9-2012 | |
001 | 3 | 18-9-2012 | |
002 | vinodh | 1 | 2/4/2012 |
002 | 2 | 5/4/2012 | |
002 | 2 | 6/4/2012 | |
002 | 4 | 7/4/2012 |
what i need is Output should be like this in qlikview
document id | broker name | serial no | created on |
001 | chandu | 1 | 16-9-2012 |
001 | chandu | 2 | 16-9-2012 |
001 | chandu | 3 | 18-9-2012 |
002 | vinodh | 1 | 2/4/2012 |
002 | vinodh | 2 | 5/4/2012 |
002 | vinodh | 2 | 6/4/2012 |
002 | vinodh | 4 | 7/4/2012 |
if any one know s pls let me know
Vinodh,
You need to use Transformation step as follows:
Directory
;
LOAD [document id],
[broker name],
[serial no],
[created on]
FROM
[..\..\..\..\..\..\..\Documents\QlikView\Test\script.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(
Replace(2, top, StrCnd(null))
));
Vinodh,
You need to use Transformation step as follows:
Directory
;
LOAD [document id],
[broker name],
[serial no],
[created on]
FROM
[..\..\..\..\..\..\..\Documents\QlikView\Test\script.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(
Replace(2, top, StrCnd(null))
));
Load the file as 2 differnt tables.
See Sample
Thank u very much .....it is working good
Here it is attached.
thanks a lot