Splunk Search

SPLUNK ITSI (Cloud)

Loves-to-Learn Lots

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.

Labels (1)
0 Karma