topic Re: How to get the value by using wildMatch in Qlik Automate

How to get the value by using wildMatch

Nagaraj6 — Tue, 04 Jul 2023 09:06:17 GMT

Hello Guys,

I need a help!

Below my field data coming like this

FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=231.0,CJN=175.0,SJN=175.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=231.0,CJN=213.0,SJN=213.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=232.0,CJN=176.0,SJN=176.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=e142.0,YR=180.0,TTF=233.0,C.JN=176.0,SJN=176.0=FSC=0.0,JN=0.0,PSF=236.0,UDF=177.0,YR=100.0,TTF=219.0,IJN=329.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=233.0,IJN=353.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=235.0,CJN=178.0,SJN=178.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=235.0,IJN=357.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=236.0,CJN=178.0,SJN=178.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=236.0,CJN=179.0,SJN=179.0=FSC=0.0,JN=0.0,PSF=236.0,UDF=177.0,YR=100.0,TTF=275.0,IJN=412.0
FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=238.0,CJN=180.0,SJN=180.0

I want to extract the data CJN & SJN value's sometimes CJN and SJN position are changing thats why I am using wildmatch .

I am not getting proper out.I need individual CJN column and SJN column of data.

Re: How to get the value by using wildMatch

marcus_sommer — Tue, 04 Jul 2023 09:47:44 GMT

I wouldn't extract those values per wildmatch() else transforming it into a normal table-structure per subfield(), maybe something on this way:

load *, subfield(FieldPart, '=', 1) as DataType, subfield(FieldPart, '=', 2) as Value, rowno() as RowNo;
load Field, subfield(Field, ',', iterno()) as FieldPart, iterno() as Iterno, recno() as RecNo
from Source while iterno() <= substringcount(Field, ',');

Re: How to get the value by using wildMatch

BrunPierre — Tue, 04 Jul 2023 10:42:11 GMT

@Nagaraj6 Is this what you're looking for?

LOAD *, Alt(Num#(TextBetween(Field,'CJN=',','),'#,##0.00'), 0) as "CJN Value", Alt(Num#(TextBetween(Field,'SJN=',''),'#,##0.00'), 0) as "SJN Value" Inline[ Field 'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=231.0,CJN=175.0,SJN=175.0' 'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=231.0,CJN=213.0,SJN=213.0' 'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=232.0,CJN=176.0,SJN=176.0' 'FSC=0.0,JN=0.0,PSF=236.0,UDF=e142.0,YR=180.0,TTF=233.0,C.JN=176.0,SJN=176.0=FSC=0.0,JN=0.0,PSF=236.0,UDF=177.0,YR=100.0,TTF=219.0,IJN=329.0' 'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=233.0,IJN=353.0' 'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=235.0,CJN=178.0,SJN=178.0' 'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=235.0,IJN=357.0' 'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=236.0,CJN=178.0,SJN=178.0' 'FSC=0.0,JN=0.0,PSF=236.0,UDF=142.0,YR=180.0,TTF=236.0,CJN=179.0,SJN=179.0=FSC=0.0,JN=0.0,PSF=236.0,UDF=177.0,YR=100.0,TTF=275.0,IJN=412.0' ]; EXIT SCRIPT;

Re: How to get the value by using wildMatch

Nagaraj6 — Tue, 04 Jul 2023 11:19:26 GMT

@BrunPierre Thank you! Yeah ,I am looking this only.