Solved! Go to Solution.
yes i have tried already. but its not working. do you think this behavior can perform a certain action to a large number of data processing?
can you help me check if this is correct. I want transfer all the values in the [message] from my table mp_l_preownership to the table doc_t_sms_sent column [message].
Hi @Audit_CKGoC
This looks correct to me.
I would add the UNIQUEID() expression for the key_column as well, unless you have set it yet with an initial value.
Then, in order to apply this action to a set of rows, you may want to use this action too (here is an example):
For reference:
i would like to confirm my For a record of this table is the mp_l_preownership (where my data came from) and my referenced table is doc_t_sms_sent (destination table)?
This is the idea, indeed.
You may want to give it a try, in order to better understand how this works.
It is working now. but how can i make my key id in order? ive already set it to [_rownumber]-1 as initial value. its working if manually add. but if adding rows using bot it is not working.
Hi @Audit_CKGoC
You probably would want to set key_column initial value differently, or set the key_column on another column.
For information:
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |