Need Help

[gireesh1216]

Hello Team,

Need your help on below scenario.

I have two columns like column1 and column2.In column1 we have column2 data as well like (ABC,DEF).

I tried in qlikview  front end its working fine. Used wildmatch function()      ▼

=IF(WildMatch(Column1,'*ABC*')=1,'ABC',IF(WildMatch(Column1,'*def*')=1,'def'))

How to achieve this in backend qlikview script?

Coumn1	Column2
Data-data-ABC-store,def-data--store1	ABC
Data-ABC-data--store	ABC
Data-data-ABC,Data-data-def-store2	ABC
def-data--store	def
Data-data-def-store	def
Data-data-def-def,Data-ABC-data--store	def

Results:

Coumn1	Column2
Data-data-ABC	ABC
Data-ABC-data--store	ABC
Data-data-ABC	ABC
def-data--store	def
Data-data-def-store	def
Data-data-def-def	def
def-data--store1	def
Data-data-def-store2	def

[tresesco]

One solution, perhaps could be like:

Source:

Load

SubField(Column1, ',') as Column1,

Column2

Inline [

Column1| Column2

Data-data-ABC-store,def-data--store1| ABC

Data-ABC-data--store| ABC

Data-data-ABC,Data-data-def-store2| ABC

def-data--store| def

Data-data-def-store| def

Data-data-def-def,Data-ABC-data--store| def] (delimiter is '|');

Join (Source)

Load Distinct Column2 as Column3 Resident Source;

NoConcatenate

Final:

Load

Column1,

Column3 as Column2

Resident Source Where Index(Column1, Column3);

Drop table Source;

[fabdulazeez]

INPUT:

Load * Inline

[Column1, Column2

'Data-data-ABC-store,def-data--store1','ABC'

'Data-data-ABC,Data-data-def-store2', 'ABC'

'def-data--store', 'def'];

INPUT2:

Load

concat( chr(39) & '*'&Column2&'*' & chr(39) , ',') as input

Resident INPUT;

Let vInput= peek('input',-1,'INPUT2');

INPUT3:

Load

Column1,

WildMatch(Column1,$(vInput)) as test,

wildmatch( 'fex', 'ja*','fe?','mar') as test2

Resident INPUT;