Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jozisvk11
Creator
Creator

Choose from table

Hello,  I have problem, how can I choose certain data from my table.

My table is:

IDNiveau 1Niveau 2Niveau 3Niveau 4
T10V20V02V96V52
T11V28J01V95V59
T12V25J02V56V29
T13J00V69V65V38
T14V29V36V51V81
T15V35V63J69V99

...

I want to choose only ID, where is J** in some Niveau.

Result table should be:

IDResult
T11J01
T12J02
T13J00
T15J69

How can I do this with some set analyse ?

Thank you for helping me.

1 Solution

Accepted Solutions
balar025
Creator III
Creator III

Please find application as solution.

I would advice you can do this logic at script level.

View solution in original post

3 Replies
balar025
Creator III
Creator III

Please find application as solution.

I would advice you can do this logic at script level.

rahulpawarb
Specialist III
Specialist III

Script level workaround:

Data:

LOAD * INLINE [

ID, Niveau 1, Niveau 2, Niveau 3, Niveau 4

T10, V20, V02, V96, V52

T11, V28, J01, V95, V59

T12, V25, J02, V56, V29

T13, J00, V69, V65, V38

T14, V29, V36, V51, V81

T15, V35, V63, J69, V99

];


Result:

LOAD ID, [Niveau 1] AS Result

Resident Data

Where Left([Niveau 1],1) = 'J' ;

LOAD ID, [Niveau 2] AS Result

Resident Data

Where Left([Niveau 2],1) = 'J' ;

LOAD ID, [Niveau 3] AS Result

Resident Data

Where Left([Niveau 3],1) = 'J' ;

LOAD ID, [Niveau 4] AS Result

Resident Data

Where Left([Niveau 4],1) = 'J' ;

Regards!

Rahul Pawar

balar025
Creator III
Creator III

Rahul, this is what i was talking.

we can go for compact code, 😛

Load *,

if(WildMatch([Niveau 1],'J*'),[Niveau 1])&if(WildMatch([Niveau 2],'J*'),[Niveau 2])&if(WildMatch([Niveau 3],'J*'),[Niveau 3])&if(WildMatch([Niveau 4],'J*'),[Niveau 4]) as [New Niveau];