I have two source formats 1.Normal raw data format 2. Pivot table
when I try to load the pivot table there is no issue inorder to link both the tables I used cross table and then joined creating a inline table however when i do that it gives me half data and the reset of the data is not displayed .