I have a small question, i would adds the columns from a source input to every row in a target input. Each row of the target input will be duplicated for every row in the source input.
We can accomplish this using a Combine Tables step. In order for the combine tables field to work, there must be a column in each respective table to match the data on. For example, if we had a table with student demographic information and another table with student grades, we may combine the tables where the “Student_ID” fields match each other.
Since your data set does not seem to include a field to combine the data on, we can create a temporary ‘merge column’ in each dataset. To do this, we will add an Insert Text Column step to create a column called “Merge” in each table, where the value is also “Merge” (the column name/ value could really be anything). I mocked up an example here using your test data:
Once we have created this merge field, we can combine the tables using the Combine Tables step. Be sure to first connect your “Input 1” data to the Combine Tables step (using the connection arrow) before connecting “Input 2.” Here is a look at the step settings:
welcome to the community!
