Hey Guys, quick question, I have two tables both have 64 rows, I am trying to combine their data in third table side by side using ''write to table'' function . Let's say table 1 has column A,B,C and table 2 has columns D,E,F. When I write them to the third table the values of table 1 start from row 2 in table 3 and the values of table 2 start from row 66 however I want them side by side in the same row. How to resolve this issue?
The write to table function creates new rows for each source table rather than combining data side by side. To merge data from two tables horizontally, you need to use a different approach. First, transfer data from both tables to your third table using write to table's column mapping feature - enter "/" to skip list selection and map columns directly. Then use our Merge Columns feature to combine the data horizontally: click Add Column, select Merge Columns, and input your formula to combine the desired columns from both source tables. This two-step process will give you the side-by-side data layout you're looking for.
I'm not sure how this can be done using merge columns feature
The merge columns feature combines data from existing columns within the same table, not for joining separate tables side by side. For your use case with two 64-row tables, you need a different approach: 1. Use write to table to transfer data from Table 1 (columns A,B,C) to Table 3 2. Use write to table again to transfer data from Table 2 (columns D,E,F) to the same Table 3, mapping to different columns 3. Enter "/" to skip list selection and map columns directly This creates one table with all six columns (A,B,C,D,E,F) with matching row data side by side.
It didn't work
