Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

It is possible to use 'SubField' to an entire table?

It is possible to use 'SubField' to an entire table?

Tags (1)
5 Replies
bill_markham
Not applicable

Re: It is possible to use 'SubField' to an entire table?

Raúl


Yup, if it is in your script as part of the Load statement that create the resident table.



Best Regards,     Bill

swuehl
Not applicable

Re: It is possible to use 'SubField' to an entire table?

Could you explain a bit more detailed what you want to achieve?

You can apply subfield to each field and then get the cross product of all possible combinations:

LOAD subfield(A,';') as A, subfield(B,';') as B INLINE [

A, B

1;2, 2;3

];

Not applicable

Re: It is possible to use 'SubField' to an entire table?

The problem here is the Table has a thousands of Columns, and thats why i want o know if it is possible to use the Subfield all the fields without put it on each one, thank you!

swuehl
Not applicable

Re: It is possible to use 'SubField' to an entire table?

Not that I can remember a way right now. And I don't think it's a good idea to create a cross product from a thousand++ columns' values.

Not applicable

Re: It is possible to use 'SubField' to an entire table?

First of all, Please read your requirements carefully and please answer the question "Is it necessary to load all thousands columns into Report" yourself and load only required fields only. This is will improve the optimization and user response time on the UI.

You can use subfield in your scenario with carefully .