All true values comes into new columns

[Srinivas]

Hi All,

I Have different columns in that some values are matched and some are not matched so whatever matched those are TRUE if not matched those are FALSE(Here have one flag once see the attached then u can understand).

Here my query is all matched values comes into one NEW COLUMNS like i attached screen shot way and also data.

(My Out put is as same Screenshot way)

Could you please help on this.

Regards

munna

[Srinivas]

Hi All,

my script is like below way but it's not working.

LOAD ID,

     CD,

     SCD,

     NUMBER,

     ITEM,

     if(Flag='TRUE',value) as PROD,

     Flag

FROM

(biff, embedded labels, table is Sheet1$);

Regards

Munna

[senpradip007]

As per your png file you can use like

Load

     ID,

     CD,

     SCD,

     NUMBER,

     ITEM,

     Flag,

     If(Flag='TRUE', ITEM) As Prod

From <>;

[Srinivas]

Thanks for your reply Pradip,But not coming correct values.

[senpradip007]

Could you please upload sample qvw?

[senpradip007]

PFA

[jyothish8807]

Hi Munna,

Try this.

Load

     ID,

     CD,

  SCD,

     NUMBER,

     ITEM,

     Flag,

     If(text(Flag)='TRUE', SCD,"") As New_Col

From <>;

Regards

KC