topic Re: how can we insert(add) missing numbers. in QlikView

how can we insert(add) missing numbers.

Mon, 26 Jan 2026 16:26:21 GMT

We have some set of data like,

how can we add missing values in between like i.e. "BFU00103,BFU00106", help me on this..

Re: how can we insert(add) missing numbers.

sujeetsingh — Fri, 30 Jan 2015 04:55:37 GMT

Why you want to insert data?

Can you please come in more words please.

Re: how can we insert(add) missing numbers.

Fri, 30 Jan 2015 05:00:39 GMT

as per requirement need to insert the values at QV script end.we have add no. in series.

Re: how can we insert(add) missing numbers.

Fri, 30 Jan 2015 06:11:54 GMT

Hi,

I m not clear, why u want to add missing values.

But when we want to add a new values to the existing field,

1.Load the new values to be added in the inline table with the same column name

2.concatenate the master table with the inline

Regards

Sudha

Re: how can we insert(add) missing numbers.

Fri, 30 Jan 2015 06:22:49 GMT

thats correct Sudha, but we have to do it manually by finding and adding the missed value in to the table,

i want the solution like,if some value "BFU00103" is missing in between " BFU00102 and BFU00104" values, script will find the value automatically and generate it in to the table.

thanks for the help..

Re: how can we insert(add) missing numbers.

MarcoWedel — Fri, 30 Jan 2015 07:19:29 GMT

How to populate a sparsely populated field

hope this helps

regards

Marco

Re: how can we insert(add) missing numbers.

Fri, 30 Jan 2015 09:32:36 GMT

as per the requirement..its working perfect.

thankss.. Marco

Re: how can we insert(add) missing numbers.

MarcoWedel — Fri, 30 Jan 2015 10:23:18 GMT

You're welcome

Please close your thread

thanks

regards

Marco