Dimension Data Match

[saifuddin]

Hi All, 

Need advice with one of the issue I am facing. I have created a table with 2 dimensions and both have the match, but at one dimension it creates an empty row. What could be the possible reason? 

Blank row

The scripting is quite complex, connected from multiple source.

Thanks

Saif

[asinha1991]

how is start date and end date connected, are they part of same table?

Is start date acting as key between two table?

if start date is acting as key, maybe one of the table has text and other has date(hence not forming join and showing redundant). you can convert text into date using date# in that case.

need to see script or data model view (table viewer) to understand better

[jyothish8807]

try this:

date(floor(Start date),'DD/MM/YYYY')  as StartDate

I guess the issue is because you have more than 1 "Start date" field which are not inline. One of the filed might have some kind of timestamp.

Else issue could be with the data model where "Start date" is mapped to both "End date" and all dates are mapped to a null() value in end date.

[Vegar]

Maybe your data is like this

Transactions:
Load * inline [
Order, StartDate, Amount
1, 3/03/2003, 100
2, 3/03/2003, 200
3, 4/04/2003, 400
4, 4/04/2003, 500
];
Order:
Load * Inline [
Order, End date
1, 27/06/2014
3, 12/12/2014
];