Appending to Binary Contents in Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-2828547%22%20slang%3D%22en-US%22%3EAppending%20to%20Binary%20Contents%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2828547%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20with%20a%20complex%20simulation%20that%20measures%20events%20to%20the%20tenth%20of%20a%20second%2C%20in%20a%20two%20sided%20stochastic%20model%2C%20with%20scenarios%20that%20can%20last%20up%20to%20360%20hours%2C%20so%20I%20have%20sometime%201%2C000%2C000%20plus%20rows%20in%20a%20.csv%20file.%26nbsp%3B%20Power%20Query%20easily%20imports%20the%20data%20and%20shows%20me%20a%20binary%20column%20with%20%22content%22%20that%20has%20the%20header%20and%20row%20info%20for%20the%20replication%20of%20the%20scenario%20game.%26nbsp%3B%20I%20normally%20run%2033%20replications.%26nbsp%3B%20It's%20easy%20to%20parse%20out%20the%20name%20of%20the%20case%20I%20am%20running%20and%20the%20replication%20%7Bseed%7D%2C%20but%20I%20cannot%20figure%20out%20how%20to%20append%20this%20data%20to%20the%20%22content%22%26nbsp%3B%20%2F%20discrete%20rows%20of%20the%20binary%20column.%26nbsp%3B%20Can%20anyone%20help%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2828547%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2828604%22%20slang%3D%22en-US%22%3ERe%3A%20Appending%20to%20Binary%20Contents%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2828604%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1180052%22%20target%3D%22_blank%22%3E%40Jimm74%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20it%20possible%20to%20provide%20sample%20file%20which%20illustrates%20how%20exactly%20data%20is%20structure%3F%20Not%20with%201M%20rows%2C%20just%2010%20could%20be%20enough.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I work with a complex simulation that measures events to the tenth of a second, in a two sided stochastic model, with scenarios that can last up to 360 hours, so I have sometime 1,000,000 plus rows in a .csv file.  Power Query easily imports the data and shows me a binary column with "content" that has the header and row info for the replication of the scenario game.  I normally run 33 replications.  It's easy to parse out the name of the case I am running and the replication {seed}, but I cannot figure out how to append this data to the "content"  / discrete rows of the binary column.  Can anyone help? 

1 Reply

@Jimm74 

Is it possible to provide sample file which illustrates how exactly data is structure? Not with 1M rows, just 10 could be enough.