How to handle data with sub listings within a row level data ?

[shekhar_analyti]

Hi All ,

How to handle data with sub listings within a row level data ? Please find attached sample data .

Example Pedros is a client which actually is group of  three separate entity of even client .

Thanks & Regards

Shekar

[shekhar_analyti]

Basically i want to ignore records like Pedros , not its sub group during load ....

[prma7799]

Like this???

Test:

LOAD Shipping_Client,

     Nautical_Miles,

     Max_Stops,

     Staked

FROM

(ooxml, embedded labels, table is Ships, filters(

Remove(Row, Pos(Top, 15)),

Remove(Row, Pos(Top, 13)),

Remove(Row, Pos(Top, 10)),

Remove(Row, Pos(Top, 7)),

Remove(Row, Pos(Top, 3))

));