2 Replies Latest reply on Nov 15, 2017 9:48 AM by agondek RSS
    agondek Newbie

    Merging More than 2 Infotables

    I am trying to merge 9 Infotables into one. Right now I am using Union to merge two at a time, then merge the resulting tables together. Does anyone know of a more efficient way to do this? All of the infotables have the same data shape.

     

    var result12 = Resources["InfoTableFunctions"].Union({t1:result1,t2:result2});
    var result34=Resources["InfoTableFunctions"].Union({t1:result3,t2:result4});
    var result56=Resources["InfoTableFunctions"].Union({t1:result5,t2:result6});
    var result78=Resources["InfoTableFunctions"].Union({t1:result7,t2:result8});
    var result14=Resources["InfoTableFunctions"].Union({t1:result12,t2:result34});
    var result58=Resources["InfoTableFunctions"].Union({t1:result56,t2:result78});
    var result18=Resources["InfoTableFunctions"].Union({t1:result14,t2:result58});
    var result=Resources["InfoTableFunctions"].Union({t1:result18,t2:result9});