How to load fields dashboard wise Y/N

[vikasmahajan]

Dear All,

I have fields like following structure in excel sheet , depending on flag "Y"  I want to load the fields dashboard wise.

how to achieve the same ?

FieldName	Dashboard1	Dashboard2	Dashboard3	Dashboard4
Field1,	Y	Y	Y	N
Field2,	Y	Y	Y	Y
Field3,	Y	N	Y	Y
Field4,	Y	Y	N	Y
Field5,	N	Y	Y	Y

Attached excel fields.

Thanks in Adv

Vikas

[Anonymous]

See if this helps?

Data:
CrossTable(DashboardNo,Field,1)
LOAD * INLINE [
FieldName, Dashboard1, Dashboard2, Dashboard3, Dashboard4
Field1, Y, Y, Y, N
Field2, Y, Y, Y, Y
Field3, Y, N, Y, Y
Field4, Y, Y, N, Y
Field5, N, Y, Y, Y
];

Not sure what you mean by dashboardwise??

[Anonymous · Accepted solution]

Or this to only select where the dashboard value is 'Y'

Temp:
CrossTable(DashboardNo,Indicator,1)
LOAD * INLINE [
FieldName, Dashboard1, Dashboard2, Dashboard3, Dashboard4
Field1, Y, Y, Y, N
Field2, Y, Y, Y, Y
Field3, Y, N, Y, Y
Field4, Y, Y, N, Y
Field5, N, Y, Y, Y
];

Data:
NoConcatenate
Load * Resident Temp where match(Indicator,'Y');

Drop table Temp;