combining multiple rows into one

meadow_ryan
meadow_ryan Member
in Magic ETL

I have a table called continuity with for a specific order can have a driver, tractor, and trailer tied to that order, I'm trying to bring the data in by filtering my rows whether the type is tractor, trailer, ord driver then appending the rows together again, but nothing is coming up...could someone please provide some assitance or if this is not how append rows is supposed to work?

 

thank you

Comments

  • Valiant
    Valiant Coach

    What option do you have set in the Append widget?

  • meadow_ryan
    meadow_ryan Member

    I have it set to include all columns, have included a screenshot of the way I have it built...the filter rows each are for a specific equipment type, so equipment_type_id = 'D' is drivers, equipment_type_id = 'T' is trailers, equipment_type_id = 'L' is tractors

Categories