Forum Discussion
MarceloBenavide
2 years agoQrew Cadet
are you using a do-loop to loop through the 4k records and make changes to each of the 20 fields in each iteration?
------------------------------
Marcelo Benavides
------------------------------
- ChayceDuncan2 years agoQrew Captain
If possible instead of doing any kind of loop you should just make a table to table import to move your fields inbetween your different subsets and have a pipeline run the import. It'll be more effiicient that way
------------------------------
Chayce Duncan
------------------------------ - AaronB2 years agoQrew Trainee
Marcelo,
Basically...yes.
Pipeline Step A: Pipeline triggered
Step B: Search for all the records in the table Query: {3.GT.0}
For each record: Step C: Update Record (values in fields 11-15 moved to fields 16-20)
Step D: Update Record (values in fields 6-10 moved to fields 11-15)
Step E: Update Record (values in fields 1-5 moved to fields 6-10)
End for each.
------------------------------
Aaron B
ab1692@att.com
------------------------------