I have an urgent requirement to build a datasets where I have to create multiple fields based on a flag field.
eg. but if the flag field(Flag_columnA ) has value 1 then 4 fields should be loaded with data.
Flag_columnA = 1, ColumnA1= ***, ColumnA2= ***, ColumnA3= ***, ColumnA4= ***( 4 fields created)
but if the flag field has value 4 then these 4 column should be repeated 4 times( replication of 4 Fields created )
if Flag_ColumnA1=4, ColumnA1= ***, ColumnA2= ***, ColumnA3= ***, ,ColumnA4= ***,
ColumnA1= ***, ColumnA2= ***, ColumnA3= ***, ,ColumnA4= ***,
ColumnA1= ***, ColumnA2= ***, ColumnA3= ***, ,ColumnA4=***,
ColumnA1= ***, ColumnA2= ***, ColumnA3= ***, ,ColumnA4= ***,
Can you please let me know how to achieve this.
