How to get the column name as the value

Question

hi all, I have two tables or more as the source data, as the pics below.

the two left tables are supposed to be unioned like the right table.

I dk how to make it? the workflow sample is attached.

Any suggestions will help. Many thanks!

Molly

test workflow.yxmd

gabrielvilella · Accepted Answer

Hi @cyg3003, you can use the Transpose tool and then Union.

grazitti_sapna · Accepted Answer

Hi @cyg3003, another way of solving the problem.

Thanks!