Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
in my Req am using two inline tables but second table cust name is populating but for that custmoer there is no sales person but in my final report both r displaying so how to avoid karthik in my report pls find attached doc
Not sure, but may be this:
LOAD * INLINE [
Sales per name, tar_cust, item, tar_amt
abc, vinod, Laptop, 200
xyz, vinod, printer, 300
cde, vinod, printer, 500
];
Left Join
LOAD * INLINE [
Trans, item, sales, cust name
1, Laptop, 100, vinod
2, printer, 100, vinod
3, printer, 200, vinod
4, printer, 400, karthik
]
Where Exists(tar_cust, [cust name]);
Not sure, but may be this:
LOAD * INLINE [
Sales per name, tar_cust, item, tar_amt
abc, vinod, Laptop, 200
xyz, vinod, printer, 300
cde, vinod, printer, 500
];
Left Join
LOAD * INLINE [
Trans, item, sales, cust name
1, Laptop, 100, vinod
2, printer, 100, vinod
3, printer, 200, vinod
4, printer, 400, karthik
]
Where Exists(tar_cust, [cust name]);
Try like:
LOAD * INLINE [
Sales per name, tar_cust, item, tar_amt
abc, vinod, Laptop, 200
xyz, vinod, printer, 300
cde, vinod, printer, 500
];
Left Join
LOAD *,
[cust name] as [Sales per name]
INLINE [
Trans, item, sales, cust name
1, Laptop, 100, vinod
2, printer, 100, vinod
3, printer, 200, vinod
4, printer, 400, karthik
];