i am facing a small issue in my office

[#1]

i m attaching exel file in which sheet 1 contains data and sheet 2 contains output please help as soon as possilbe

[bohravanraj]

Hi Amit,

Please will you elaborate more about your query.

[trdandamudi]

May be as below: Hope this helps,,,

Source_Data:

Load * Inline [

PolicyNo,Code

1000, 1

1000, 2

1000, 6

2000, 2

2000, 6

4000, 2

3000, 3

5000, 4

6000, 5

7000, 7

7000, 5

];

Mapping:

Mapping Load PolicyNo,'Yes'

Resident Source_Data

Where Code=6;

Final:

NoConcatenate

Load

PolicyNo,

Code,

ApplyMap('Mapping',PolicyNo,'No') as Output

Resident Source_Data;

Drop Table Source_Data;

[#4]

Is this what you're trying to accomplish?

SourceData:

LOAD * INLINE [

    PolicyNo, Code

    1000, 1

    1000, 2

    1000, 6

    2000, 2

    2000, 6

    4000, 2

    3000, 3

    5000, 4

    6000, 5

    7000, 7

    7000, 5

];

Output:

Load if(Code=6,PolicyNo) as PolicyNumber,

  if(Code=6,'Yes') as Output

Resident SourceData;

Concatenate

Load PolicyNo as PolicyNumber,

  'No' as Output

  Resident SourceData

Where Not Exists (PolicyNumber,PolicyNo);

Drop table SourceData;

[MarcoWedel]

Hi,

one solution could be:

tabIn:
LOAD * FROM [https://community.qlik.com/servlet/JiveServlet/download/1162480-254322/Senario.xlsx] (ooxml, embedded labels, table is Sheet1);

tabOut:
LOAD [Policy No],
     If(Min(Code=6),'Yes','No') as Output
Resident tabIn
Group By [Policy No];

hope this helps

regards

Marco

[el_aprendiz111]

Hi,

Senario:
LOAD *, IF(Code=6,'Yes','No') AS Output;
LOAD * INLINE [
PolicyNo, Code
1000, 1
1000, 2
1000, 6
2000, 2
2000, 6
4000, 2
3000, 3
5000, 4
6000, 5
7000, 7
7000, 5
];

[#7]

thnks

[#8]

thnks

[#9]

thnks

[MarcoWedel]

you're welcome

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco