topic Re: one extra row in QlikView

one extra row

kamal_sanguri — Tue, 07 Jun 2016 11:32:06 GMT

Hi All,

I was trying to execute below code.. and I think I should get only one row... however I am getting two..

Load *

inline

[

field

Great_CAll

];

load field,

SubField(field,'_CAll') as client

Resident a;

drop table a;

EXIT Script;

Re: one extra row

sunny_talwar — Tue, 07 Jun 2016 11:33:43 GMT

You will get 2 because you have no specified the third argument. May be try this:

Load *

inline

[

field

Great_CAll

];

load field,

SubField(field,'_CAll', 1) as client

Resident a;

drop table a;

EXIT Script;

Re: one extra row

kamal_sanguri — Tue, 07 Jun 2016 11:42:47 GMT

Hi Sunny,

I was 100% sure that you will give me answer for this.. thanks.. could you elaborate it.. I still don't understand, why it is giving an additional row?

Re: one extra row

susovan — Tue, 07 Jun 2016 11:43:22 GMT

Hi Kamal,

Try This

Load *

inline

[

field

Great_CAll

];

load field,

SubField(field,'_CAll','_') as client

Resident a;

drop table a;

EXIT Script;

Re: one extra row

sunny_talwar — Tue, 07 Jun 2016 11:45:40 GMT

Without the third argument SubField behaves like a loop. Since there is only one _CAll it will loop twice. If there were 2, then it would have looped thrice. So general rule here is if you have n _CAll, it will loop n+1 times. In your case you might think that there is nothing after _CAll, but it will still create an extra row with empty cell. Does that make sense?

Re: one extra row

susovan — Tue, 07 Jun 2016 11:46:13 GMT

Check this link,

Link:http://webofwork.com/splitting-a-string-into-seperate-fields-using-subfield/

Re: one extra row

kamal_sanguri — Tue, 07 Jun 2016 11:50:49 GMT

absolutely.. learnt new thing..