Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
As per your png file you can use like
Load
ID,
CD,
SCD,
NUMBER,
ITEM,
Flag,
If(Flag='TRUE', ITEM) As Prod
From <>;
Thanks for your reply Pradip,But not coming correct values.
Could you please upload sample qvw?
PFA
Hi Munna,
Try this.
Load
ID,
CD,
SCD,
NUMBER,
ITEM,
Flag,
If(text(Flag)='TRUE', SCD,"") As New_Col
From <>;
Regards
KC