Hi,
I need to append tables with different column orders but have the same header for the respecitve columns. For example
A.Properties.VariableNames={'org01','org02','org03','org04',SQ001','SQ002',SQ003'};
B. Properties.VariableNames={'org01','org03','org02',SQ002','SQ003',SQ001'};
How can I append B columns to A columns for the columns that have the same header while assigning for the variables in A that don't have equivalent in B such as org04 NaN values.
Best Answer