Hi Experts,
I need to proces an External file and store into a table. Here need to Split the fields in a row and write as multiple rows of a table.
here i am giving the data sample ..
outlet1 type1 type2 type3
outlet2 type1 type3 type4 typ6 type7
The table should be as below.
outlet1 type1
outlet1 type2
outlet1 type2
outlet2 type1
outlet2 type3
outlet2 type4
outlet2 type6
outlet2 type7
Please give your suggesions and code sample that you have
Thanks