4.11 Merge by column - one to many - copy data

 

Before merging:

Types.xlsx
imagepng

Foods.xlsx
imagepng

After merging:
imagepng

Script:

A
1 =T(“Types.xlsx”)
2 =T(“Foods.xlsx”)
3 =join@f(A1:Type,Type;A2:Food,Type)
4 =A3.new(Food.Type,Food.Name,Food.UnitPrice,Type.Description)
5 =T(“FoodsDescription.xlsx”,A4)

A3: @f means full join


esProc Desktop and Excel Processing
4.10 Merge by column - convert file names to column names
4.12 Merge by column - one to many - leave subsequent rows empty