topic Re: How to Create Dummy records in QlikView

How to Create Dummy records

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a Field called Material code which contains some data.

For Example:

Material Code:

I have to add 0 as a dummy value for each Records.How can I do this in the script.Could Anyone help me in this

Thanks

Re: How to Create Dummy records

sunny_talwar — Tue, 20 Jun 2017 13:52:17 GMT

May be Concatenate?

Table:

LOAD [Material Code],

OtherFields....

FROM ...

Concatenate (Table)

LOAD 0 as [Material Code]

AutoGenerate 1;

Re: How to Create Dummy records

CarlosAMonroy — Tue, 20 Jun 2017 13:52:56 GMT

Hi Sindhu,

Go to the script -> Insert Menu -> Load Statement -> Load Inline

LOAD * INLINE [

Material, Plant

A, AA

B, BB

C, CC

D, DD

];

Hope that helps,

Carlos M

Re: How to Create Dummy records

Anonymous — Wed, 21 Jun 2017 04:50:26 GMT

Hi,

Thanks for your rly.

But this concept is not generate '0' value for each record. But I need '0' for each material code.Can u help me to find solution.

Re: How to Create Dummy records

Anonymous — Wed, 21 Jun 2017 04:51:06 GMT

Hi,

Thanks.

But I have more no of material code..How can I do by use Inline Load.

Re: How to Create Dummy records

Anil_Babu_Samineni — Wed, 21 Jun 2017 05:00:28 GMT

Can you elaborate more about your expected result?

Re: How to Create Dummy records

Anonymous — Wed, 21 Jun 2017 05:13:59 GMT

When I select one material code,it'll show some value. if there is no value means it should display 'Zero'.

I used pivot table and not getting proper result in 'Show all values and Suppress Zero values'.

So I planned to create some dummy data for each material code.

Re: How to Create Dummy records

Anil_Babu_Samineni — Wed, 21 Jun 2017 05:17:42 GMT

Like this?

Re: How to Create Dummy records

Anonymous — Wed, 21 Jun 2017 05:26:32 GMT

Material Code ABC12 will have both Stock value as well as Zero value. When there is no Stock value it should display Zero.This is what I want..

Re: How to Create Dummy records

Anil_Babu_Samineni — Wed, 21 Jun 2017 05:38:40 GMT

I am sorry, If i misunderstand the Rek. Better if you provide sample data and expected result

From below, What are you expecting?

Re: How to Create Dummy records

jyothish8807 — Wed, 21 Jun 2017 05:57:46 GMT

Hi Sindhu,

Try like this:

table1:

Load

[Material code]

from ABC.xlsx;

left join

load

[Material code],

'0' as Dummyfield

resident table1;

Regards,

Re: How to Create Dummy records

Anonymous — Wed, 21 Jun 2017 05:59:48 GMT

Your Understanding is correct only..But I need for all Material Code

I need like this below screenshot..

Re: How to Create Dummy records

Anonymous — Wed, 21 Jun 2017 06:18:20 GMT

Hi Jyothish,

Thanks for your rly.But this concept is not suite for my expectation.if u don'tundrstand pls let me know.

Re: How to Create Dummy records

Anonymous — Wed, 21 Jun 2017 06:37:15 GMT

Hi Anil,

Is this possible to create? Can u help me.

Thanks in advance

Re: How to Create Dummy records

jyothish8807 — Wed, 21 Jun 2017 06:40:03 GMT

You will get 0 for all material code. Can you explain your requirement in detail ?

Br,

Re: How to Create Dummy records

jyothish8807 — Wed, 21 Jun 2017 06:41:18 GMT

Try like this:

table1:

Load

[Material code],

[Stock Value]

from ABC.xlsx;

left join

load

[Material code],

'0' as [Stock Value]

resident table1;

Regards,

Re: How to Create Dummy records

Anonymous — Wed, 21 Jun 2017 06:50:27 GMT

Hi Jyothish,

Thanks for ur response.

I have two tables one is master(item master) and one is fact table. Material Code should fall with the value and zero. Please refer attached screen shot.

Re: How to Create Dummy records

jyothish8807 — Wed, 21 Jun 2017 06:59:46 GMT

Try my below code..

Regards,

Re: How to Create Dummy records

Anonymous — Wed, 21 Jun 2017 07:00:12 GMT

Hi Jyothish,

Material Code is in master table and stock value is in fact table..did u get dt? I have to add 'Zero' in material code itself, not in the stock value.

Thanks again for ur Fast response.

Re: How to Create Dummy records

Anil_Babu_Samineni — Wed, 21 Jun 2017 07:04:08 GMT

I am not sure, By the way helps to you

Sample:

LOAD * Inline [

Material Code, Stock Value

ABC12, 10

DFE23, 10

kfdfds43, 20

fsd32, 30

klt67, 40

];

Join

LOAD [Material Code],'0' as [Stock Value] Resident Sample;

Output: