Hi @Dmitriy Maslennikov 
This suggestion worked thanks, one I am looping over 60 columns and all is working fine. One thing is breaking sometimes data is single codes ' in the text and such records are not being saved. Any suggestion how to handle this?

For i=1:1:60 {
set FieldName = FieldName_",Field"_i
set FieldVaue = FieldVaue_"','"_$Piece(pInput,"|",i)}

Best Practices to Common Problems: This will be quick start to implement real time example not generic documentation which is hard to follow and real things are not visible

Master data management, This will have single place to have all master data and every system/compoent using such master data. Like Facility Registry, same used in routing rules, healthinsight. Same Gender, its used in data quality, validation, in reports, in mapping, in outbound interfaces