Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
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!
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.
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 .