Flag issue?

[#1]

Hi All,

I am Having a Flag, in That one i am having only 'Y',

If I am Selecting Flag as 'Y', I am getting the Correct Item No....

I am Having 2000 Items..If I am Selecting Flag as 'Y', I am getting the Correct Item Nos, BUt Items are decreasing upto 1500..(500 Items are Missing)

I need to Show all 2000 Items by selecting the Flag as 'Y' with  Correct O/P...

Help me Some one...

Regards,

Heather

[jyothish8807]

Hi Heather,

It sound a little confusing.

If I am Selecting Flag as 'Y', I am getting the Correct Item No....

I am Having 2000 Items..If I am Selecting Flag as 'Y', I am getting the Correct Item Nos, BUt Items are decreasing upto 1500.

Can you please explain a bit more or share your app?

Regards

KC

[tresesco]

Probably the flag field and the Item field are not from the same table; the tables are linked. Try to generate the flag field in the same table as of field Item.

[jagan]

Hi,

May be for Flag Y there are only 1500 records matching, they have not given any false value, you currently flag would be like this

LOAD

*,

If(SomeDimension = 'SomeVale', 'Y') AS Flag

FROM DataSource;

If you change this to

LOAD

*,

If(SomeDimension = 'SomeVale', 'Y', 'N') AS Flag

FROM DataSource;

Now you will get two values in Flag field.

Regards,

jagan.

[its_anandrjs]

Can you provide sample file here to look out or what logic you use for the flag creation.

Regards

Anand

[#6]

HI KC,

I am having Some Articles, Some of the articles are having Two supplier No.s..

Which Items are having two Supplier No.s they are showing Blank value in the Report, for that Reason I am selecting Flag Condition ='Y' then Correct Supplier No is Coming for the Articles..

In My Report I am Having Some Articles which are not containing any Supplier No., Those articles are missing in the Report If i am selecting the Flag='Y' Condition...

I hope you can understand..

Regards,

Kacy

[MayilVahanan]

Hi,

You need to mention 'Y' as flag value for those articles doesn't have supplier no. This resolve your problem

[jyothish8807]

Hi Heather,

Try modifying your flag condition like this:

if(isnull(Supplieno)=-1 or your condition,'Y','N')

Hope it helps.

Regards

KC

[#9]

Hi KC,

Can you share some Sample App

Regards,

Kacy

[jyothish8807]

It will be helpful if you share your script  used to set the flag.

Regards

KC