How to hide data

[vinod2086]

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

[sunny_talwar · Accepted solution]

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]);

[tresesco]

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

];