How to combine variables from different workspace

Hi all

I got 5 nos. of tables named "KENJUICE1", "KENJUICE2", "KENJUICE3", "KENJUICE4" and "KENJUICE5" (46 columns with different nos. of rows) in workspace.

I would like to combine those variabes in columns named "Irms_A_avg", "PowerP_A_avg" and "PowerS_A_avg" as 3 columns with summation of "KENJUICE 1 to 5" rows.

May I know anyway to do that instead of COPY and PASTE for each workspaces?

Many thanks for the help.

[Shameer Parmar]

Hello Ken,

What is mean by 'with summation of "KENJUICE 1 to 5" rows' ?

for example, if table KENJUICE1 is of dimension 46 by 10, means it has 10 rows, and each row has 46 column, so if you do the summation of each row then you will get 10 values for 10 rows.. similar for KENJUICE2, KENJUICE3, KENJUICE4, KENJUICE5.

and now how you want to put these values to your new 3 columns.. "Irms_A_avg", "PowerP_A_avg" and "PowerS_A_avg"..

Can you explain this ??? then only we can help you..

[Ken Lee]

Hi Shameer Sorry about my poor English. I got data with columns named "Irms_A_avg", "PowerP_A_avg" and "PowerS_A_avg" with 150 rows in KENJUICE1. For other KENJUICEs, the nos. of rows of are different. What I want to do is combining different rows of "Irms_A_avg", "PowerP_A_avg" and "PowerS_A_avg" in one table to corresponding columns. Also, may I know any functio/app is suitable for waveform feature recognition? I am working on using the waveform features of juice blender to distinguish it from waveform with other appliances are on.

[Jan]

"KENJUICE1", "KENJUICE2"... Do not hide indics in the names of variables. If the variables contain equivalent objects, use an array instead, here a cell array: KENJUICE{1}, KENJUICE{2},...

[Ken Lee]

Many thanks Jan What is the difference applying variables instead of array. I checked other posts but sill no idea why shall we do it. Do you have any suggestions on waveform identification?

[Stephen23]

"What is the difference applying variables instead of array. I checked other posts but sill no idea why shall we do it"

Putting meta-data into variable names requires slow and complex code to process them.

In contrast indices are simple and very efficient.

https://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval