topic Re: Ignoring values in Script in QlikView

Ignoring values in Script

Wed, 09 Mar 2016 18:50:52 GMT

Here is my Sample data in a field , I want to ignore the values anything which has text after Payroll:v1/returns/ and Payroll:v1/submissions/ in the script .. how can I achieve this?

Thanks

Sample Data

Payroll:v1/submissions/

Payroll:v1/submissions/checklimit/

Payroll:/transactionidentityverifications

Payroll:v1/returns/

Payroll:v1/returns/numbera2461865320db320153365bd07d11f3/

Indirect Tax V3

Indirect Tax V3:taxagencyv3

Expected Output

Payroll:v1/submissions/

Payroll:/transactionidentityverifications

Payroll:v1/returns/

Indirect Tax V3

Indirect Tax V3:taxagencyv3

Re: Ignoring values in Script

sunny_talwar — Wed, 09 Mar 2016 19:17:50 GMT

May be this:

Table:

LOAD *,

// Index(Field, '/', 2) as Count,

If(Index(Field, '/', 2) > 0, Left(Field, Index(Field, '/', 2)), Field) as New_Field ;

LOAD * Inline [

Field

Payroll:v1/submissions/

Payroll:v1/submissions/checklimit/

Payroll:/transactionidentityverifications

Payroll:v1/returns/

Payroll:v1/returns/numbera2461865320db320153365bd07d11f3/

Indirect Tax V3

Indirect Tax V3:taxagencyv3

];

Re: Ignoring values in Script

Wed, 09 Mar 2016 19:20:41 GMT

there are these type of values also ,which I still wanted to be .. so I think we have to explicitly mention the values

Payroll:v1/submissions/ and Payroll:v1/returns/

Payments:/case-management-ws/v1/calendarDate

Payments:/case-management-ws/v1/merchant/number/cases/number/documents

Re: Ignoring values in Script

maxgro — Wed, 09 Mar 2016 19:35:57 GMT

Table:

LOAD *

where match(Field, 'Payroll:v1/returns/', 'Payroll:v1/submissions/')

or not wildmatch(Field, 'Payroll:v1/returns/*', 'Payroll:v1/submissions/*')

;

LOAD * Inline [

Field

Payroll:v1/submissions/

Payroll:v1/submissions/checklimit/

Payroll:/transactionidentityverifications

Payroll:v1/returns/

Payroll:v1/returns/numbera2461865320db320153365bd07d11f3/

Indirect Tax V3

Indirect Tax V3:taxagencyv3

];