Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator II
Creator II

string processing

Hi All

I have such dataset

LOAD * Inline [

Name,                Sign 
WIND-SEP19,    W
WIND-OCT18,   W
WIND,                  W
WINDY,                 D
];
 I need to process each row with the next logic:  if  there is a "-" I need to  replace Name field value till this sign.  
As the result I will have the next table 

LOAD * Inline [

Name,                Sign 
WIND,                  W

WIND,                  W

WIND,                  W


WINDY,                 D
];

Coud you, please, tell how to apply such logic it in the load script?

 

 

Labels (1)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

Try this? 

LOAD * Inline [

Name, Sign
WIND-SEP19, W
WIND-OCT18, W
WIND, W
WINDY, D
] Where Not WildMatch(Name, 'WIND-*');

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

1 Reply
Anil_Babu_Samineni

Try this? 

LOAD * Inline [

Name, Sign
WIND-SEP19, W
WIND-OCT18, W
WIND, W
WINDY, D
] Where Not WildMatch(Name, 'WIND-*');

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post