Column level data availability flag

[Krish2459_58]

Hi,

I need to flag the column if is there more than one record as 'Y' else 'N'.

I tried this (If(len("Make Good")>0,'Y','N') as "Make Good") but it gives the row level flagging. I need at column level flagging.

Required output:

Thanks..

[Anil_Babu_Samineni · Accepted solution]

@Krish2459_58 You can try the same with ValueList() as island tabular. 

[jochem_zw · Accepted solution]

think you are trying to do it in the script editor? If so below code will work but using an aggregation function will mean you will have to use a group by also.

If(Count("Make Good")>0,'Y','N') as "Make Good"

but you can also do in a table object (not script), create an expression like this: If(Count("Make Good")>0,'Y','N') and give the expression a label

[vinieme12 · Accepted solution]

try below

=if(Count(Distinct TOTAL [Make Good])>0,'Y','N')

[Krish2459_58]

Hi,

Tried this and it works.

if(count(if(len("Make Good")=0,null(),'1'))>0,'Y','N') as "Make Good"

Thanks..