Same rows not showing in Straight table

[narender123]

Hi All,

I have 2 tables and both are joined with each other via association join by default.

When i load the data and create straight table then some of the rows are not showing .The reason behind this is :

Rows with same data are not showing in table means same repeating rows showing only 1 time.

But in oracle data all rows are showing independent of same or different rows.

Please tell me how to show all rows, independent of similarity between rows.

Thanks,

Narender

[Gysbert_Wassenaar]

Create a record number in the script when you load the data:

LOAD

     *,

     RecNo() as RecordNumber

FROM

     ...somewhere...

     ;

Then use that RecordNumber field as dimension in your straight table.

[narender123]

Thanks Gysbert.

I used it and its working.

[kamal_sanguri]

Nice trick..