Divide a Field values into 2 list boxes.

[narender123]

I have a column "Regime" and i want it divide into 2 list boxes.This fied having multiple value like C1,C2,C4S,c,E1,E2,E3,T1,T2,T3,T,Z,...   etc.

1st list box show the values start with C means C*  after that name the list box as Import and 2nd list box show the values start with E means E* after that name the list box as Export.

Thanks in advance.

[fdelacal · Accepted solution]

i THING YOU NEED SOMETHING THAT THE QVW, I ATACH.

Hope that help you.

[jagan]

Hi Narender,

In load script arrive two new fields for Import and Export

Data:

LOAD,

     Field,

     If(Field Like 'C*', Field) AS Import,

     If(Field Like 'E*', Field) AS Export

FROM DataSource;

Now you can use Import and Export filters.  Hope this helps you.

Regards,

Jagan.

[narender123]

Thanks.It is working.

[narender123]

Thanks Jagan.

Its also working.