Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the below code:
-----------------------------
LOAD @1 as [Reporting Entity],
@2 as UBR,
@3 as FSI,
@15 as [Group Settlement Amount],
@18 as Description,
@19 as [Receiving FSI],
@21 as Period
FROM
(txt, codepage is 1252, no labels, delimiter is ';', msq, header is 1 lines);
------------------------------
I have a CSV file with a content below:
V4.0;GL;R;Delta;IF;;11-19-2012;10985;100
8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101
8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101
8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101
8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101
8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101
8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101
8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101
8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101
8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101
8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101
When I constructed a table box, there is only 1 row appearing. This leads me to believe that qlikview is automatically eliminating duplicates when loading?
If this is correct, is there a way to reconfigure this so that Qlikview loads the data as it is e.g. all the 10 rows above?
Thanks
Hi,
The TableBox object will only display one of the rows. You can check this by creating the same layout in a straight table chart and setting the Expression to count({field}) or something, it will show how many identical lines there are.
You would probably be wise to add a RowNo() column to your load script and include it in your table object or use the dual function to pair this RowNo() value to one of your fields.
flipside
QV will load all rows, but a table box will only show distinct combinations of your field values.
If you do a count on one of your fields (or using the table viewer CTRL-T), you'll see that all lines are read in.
Hope this helps,
Stefan
Hi,
The TableBox object will only display one of the rows. You can check this by creating the same layout in a straight table chart and setting the Expression to count({field}) or something, it will show how many identical lines there are.
You would probably be wise to add a RowNo() column to your load script and include it in your table object or use the dual function to pair this RowNo() value to one of your fields.
flipside