This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have Master Data and 1 Fact data.
Master table has a field called Transport Number with data T1,T2,T3. But my Fact Data has a Transport Number field that has data T1,T2,T3,T4,T5,T6,T7.
I want my fact data only show data out as per the Master Table. If the Master Table only have Transport Number of T1,T2,T3. then only show T1,T2,T3 data in the Fact Table.
I need to do it in the loading script. I have also attach this sample.
Every time Fact behaves as a transactional data in itself and if you use inner join that effects the result somehow.
You can use Right Join, Right Join, Where exits also
LOAD * INLINE [
F1, F2, transport_number
qwe, q, T11
eqwe, a, T23
cbfgn, z, T1
werf, xs, T2
tryry, w, T3
qwewqe, f, T40
hmghmh, e, T50
wqewqe, v, T60
View solution in original post
Use Left Keep or Left Join master to the fact table.
My bad use Right Keep on the Fact table with get only data based on the Master Table.
Load * Inline
LOAD * Inline
No Sample Attached.
y cant i use inner join???
Sorry. My Bad.
With where Exists see the attached also.
] Where Exists(transport_number);
so right keep or where exists?