Hi,
I tried this: Extract only the specific column data from a datatable and create a new datatable with that column data - #2 by ImPratham45
But didn’t have much luck.
I have one dt1 from data scraping - it contains one column, ‘questions’
Within the same sequence, I conduct another moment of data scraping, which outputs another dt2 with one column, ‘answers’
I want to add the column ‘answers’ from dt2 into dt1 next to the ‘questions’ column.
so;
from this:
dt1:
questions |
---|
q1 |
q2 |
qn… |
and dt2:
answers |
---|
a1 |
a2 |
a3… |
to:
questions | answers |
---|---|
q1 | a1 |
q2 | a2 |
etc |
I thought I needed to use the ‘add data column’ activity - but maybe another activity might be better?